By David H. Ringstrom, CPA Show Hiding and unhiding rows and columns are mundane tasks that many users take for granted. However, sometimes simple tasks can trip up Excel users, like unhiding just one row or column within a hidden set. Other users don't know simple keystroke commands that can streamline hiding and unhiding columns or rows. In this article, I'll explore these techniques as well as discuss two powerful alternatives to manually hide and unhide rows and columns. I'll also discuss how to re-enable an Excel keyboard shortcut that's disabled in any operating system subsequent to Windows XP. Hiding Rows and Columns Let's first explore the traditional approaches to hiding rows and columns. Going forward, I'll only explain rows – simply replace the word Row with Column in any menu commands that I describe if you want to hide or unhide columns. First, select the row or rows that you wish to hide or unhide, and then carry out these steps:
Tip: Remember, to unhide rows, you must select rows on either side of the hidden set. If you're trying to unhide rows at the top of the worksheet, click on the first visible row, and then move your mouse up to the top of the screen. Keyboard Shortcuts Alternatively, you can select a row or rows, and then press Ctrl-9. To unhide rows, press Ctrl-Shift-9. For columns, use Ctrl-0 (that's a zero) or Ctrl-Shift-0, respectively. There's a catch with the latter shortcut, though. By default, Windows Vista, Windows 7, and Windows 8 use Ctrl-Shift-0 (zero) as a keyboard shortcut for changing the keyboard layout. This means that when you move from Windows XP to a newer version of Windows, Ctrl-Shift-0 no longer works in Excel unless you change an arcane Windows setting shown in Figure 1. Figure 1: The Switch Keyboard Layout option in Windows Vista and later blocks Ctrl-Shift-0 for unhiding columns in Excel. Windows 8:
Windows Vista or Windows 7:
Windows XP:
Unhide Selectively Sometimes you may want to unhide just a single row or column. There are two ways to do so: 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:
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:
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:
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:
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. A previous version of this article first appeared on www.accountingweb.com . 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 or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link
In this article, we will explain how to Unhide Column in Microsoft Excel 2007 in simple steps. Index:
Now, let’s analyze the Unhide Column in Microsoft Excel 2007 with some practical examples.
Method 1:
Method 2:
Synopsis:This article helped you on how to Unhide Column in Microsoft Excel 2007. Kindly Don’t forget to share your queries/suggestions in the below comment box & also leave your worthwhile feedback. Thanks for visiting Geek Excel!! Keep Learning with us!! Related Articles: |