hide and unhide rows in excel click excel for mac

This makes it easy to collapse and expand details of summary reports.

Each group can be expanded or collapsed with the click of a button.

Groups make it much easier for users of your worksheets to navigate your summary reports and only view detail rowscolumns as needed.

Clicking it again will expand the groups at the first level.

Clicking each number will allow you to expand and collapse the data to the level you want.

Start by select the rows or columns that you want to ungroup.

Select Clear Outline from that menu and all of the groupings youve made will disappear.

For example if you use a SUM formula, it will group all of the rows that are added together for that sum, because it assumes the data in those cells is similar enough to group together.

Then go to the Data tab, the Outline drop-down, the Group drop-down, and select Auto Outline.

So if you use Auto Outline, you may want to ungroup some of the groups if it feels like too much.

Then it doesnt outline the entire sheet, just the parts that you are interested in grouping.

These features are especially helpful if you have other users who will be accessing them.

These are two that I use frequently and recommend committing to memory.

See this post on 5 Keyboard Shortcuts for Rows and Columns in Excel to learn more.

You have any cell in the grouping selected and use these shortcuts to hideunhide the entire grouping, which is the advantage over the Ctrl ( Shift) 9 and Ctrl ( Shift) 0 shortcuts in this scenario.

Again, if you first press Shift Space or Ctrl Space to select rows or columns, you wont have to deal with the Group window when using these hiding and unhiding key combinations.

Users frequently prefer to see the expanding and contracting boxes above and to the left of the detail (in the case of a header).

Is there a way to have Subtotal count the number of rows and show that count on each subtotal row Thanks.

Hide And Unhide Rows In Excel Click Excel For Mac