Tricks for Hiding and Unhiding Excel Rows and Columns

 
1. Press Ctrl-G to display the Go To window, type in the address of a cell in the row or column that you wish to unhide, and then click OK, as shown in Figure 2. Carry out the corresponding menu command or keyboard shortcut to unhide the row or column. You can also use menu commands to display the Go To dialog box:
  • Excel 2007 and later: Choose Find and Select on the Home tab, and then click Go To.
  • Excel 2003 and earlier: Choose Edit and then Go To.
2. If you don't know the exact address of the cell you're looking for, press Ctrl-F to display the Find window and search for a word within the hidden column or row. As with the Go To command, Excel will select the hidden cell, which you can then unhide. You can also use menu commands to display the Find dialog box:
  • Excel 2007 and later: Choose Find and Select on the Home tab, and then click Find.
  • Excel 2003 and earlier: Choose Edit, and then Find.
 
Figure 2: The Go To dialog box allows you to navigate to a hidden cell when you need to selectively unhide a row or column.
 
Group Rows or Columns
 
Excel's Group feature is an effective alternative to manually hide or unhide rows and columns. Select the rows or columns you wish to hide, and then carry out this command:
  • Excel 2007 or later: Click the Group icon in the Outline section of the Data ribbon.
  • Excel 2003 and earlier: Choose Data, Group and Outline, and then Group.
As shown in Figure 3, Excel adds a button outside the worksheet frame that you can use to toggle the hidden or visible status of rows or columns. To remove grouping, select the group, and then issue the corresponding Ungroup command, which is adjacent to the Group commands described above.
 
Figure 3: The Group feature allows you to expand or collapse a set of rows or columns with a single mouse click.
 
Custom Views
Many Excel users overlook the Custom Views feature, which among other things, allows you to save sets of hidden rows or columns. Before you start hiding rows or columns, first create a view that displays the entire worksheet:
  • Excel 2007 and later: Choose Custom Views in the Workbook Views section of the View ribbon. Click Add, and then assign a name, such as All Columns. Make sure that Hidden Row, Columns, and Filter Settings is selected, and then click OK.
  • Excel 2003 and earlier: Choose View, and then Custom Views. From there, the commands are the same as described in Excel 2007.
Next, hide rows and/or columns as desired, and then save a second custom view. You can now toggle between views as needed. Issue the Custom Views command, select a view from the list, and then click View.
 
See all articles by David Ringstrom.
 
About the author:
David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
 

You may like these other stories...

You probably don't want to think about how many times you access the File menu in Excel 2010 or 2013. Personally I think Excel 2010 has the best possible File menu arrangement, other than having Print Preview grafted...
Following other recent high-profile hacking events, investigators discovered yesterday that hackers broke into the draft work paper files of several famous CPA firms. Revealing images of the scantily clad documents have been...
For bitcoin users, the taxman cometh. And you best know how to calculate taxes owed on what the IRS calls convertible virtual currency.In March 2014, the IRS issued Notice 2014-21, which declares virtual currency will be...

Already a member? log in here.

Upcoming CPE Webinars

Sep 24
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
Sep 30
This webcast will include discussions of important issues in SSARS No. 19 and the current status of proposed changes by the Accounting and Review Services Committee in these statements.
Oct 21
Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience's communication style.
Oct 23
Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.