Excel: Hide and unhide columns or rows in a single click

If you work with large workbooks, you probably hide various columns or rows in order to condense the amount of information that appears on the screen or for print outs. If you find yourself repeatedly hiding and unhiding columns/rows, you can can save time by using the the Group tool instead. This tool is designed to outline groups of information, such as quarterly sales and grand totals, but I use it for the simple convenience of collapsing and expanding portions of my workbook in a single click.

 

2018-01-26_12-06-24
To group columns or rows use the following steps.
  1. Select the columns or rows you want to hide.
  2. On the Data tab, in the Outline group (Group and Outline in Excel 2011), click Group, and then click Group.
  3. In the Group dialog box, select the Columns or Rows option.
  4. Click OK.
After you click OK, an outline symbol will appear above the last column in your selection or to the left of the last row in your selection. To collapse the columns/rows, click the Collapse (-) button. When columns/rows are collapsed, an Expand button (+) will appear. Like the Collapse button, click the Expand button to redisplay the columns or rows.
TipYou can also use the Group symbols that appear in the upper left corner of your worksheet below the Name Box to expand and collapse. Additionally, press Ctrl+8 to toggle the display of the outlining symbols.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s