Ungroup windows in excel

The groups in Excel are used to create structured financial models. Since groups provide minimize and maximize options, they are used to hide unnecessary calculations. Ungrouping removes the grouping of rows and columns, thereby helping the user go back to the initial data view. Ungrouping helps to look at the entire worksheet data in one go.

This has been a guide to Group in Excel Auto, Manual. Here we discuss how to group and ungroup data in Excel along with examples and downloadable Excel template. You may learn more about Excel from the following articles —. Download Group in Excel template. Forgot Password? Free Excel Course. Login details for this Free course will be emailed to you.

Article by Jeevan A Y. Group worksheets Ungroup worksheets Group worksheets. Read More Free Download You are guest Login Now.

Loading comment Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Autonomous Systems. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business. Humans of IT.

Green Tech. This is located in the top menu bar and will bring up a set of data-specific controls. Method 3. Click the "Subtotal" button. This button is on the right of the data toolbar in the "Outline" section and will bring up a dialog box. Click the "Remove All" button. This button is in the lower left of the dialog box and will ungroup all data and remove the subtotals.

Include your email address to get a message when this question is answered. By using this service, some information may be shared with YouTube.

You can save the file as a new version before working with the subtotal or grouping features in your spreadsheet.

This will keep you from having to return it to its previous state after ungrouping and removing subtotals. Helpful 2 Not Helpful 2. Submit a Tip All tip submissions are carefully reviewed before being published. You Might Also Like How to. How to. About This Article. Co-authored by:. Co-authors: 6. Updated: March 29, Categories: Microsoft Excel.