Tricks for Hiding and Unhiding Excel Rows and Columns
by AccountingWeb on
- Excel 2007 and later: On the Home tab, choose Format in the Cells section of the ribbon, and then choose Hide & Unhide, and then either Hide Rows or Unhide Rows.
- Excel 2003 and earlier: Choose Format, Row, and then either Hide or Unhide.
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.
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.
- Click on Language within the Control Panel.
- Click Advanced Settings, and then click the Change Language Bar Hot Keys link.
- Click Change Key Sequence, select Not Assigned in the Switch Keyboard Layout section, and then click OK as needed.
Windows Vista or Windows 7:
- Click Region and Language within the Control Panel.
- Choose the Keyboards and Languages tab, and then click Change Keyboards.
- Click the Advanced Key Settings tab, and then click Change Key Sequence.
- Select Not Assigned in the Switch Keyboard Layout section, and then click OK as needed.
- No Control Panel changes are necessary.
Sometimes you may want to unhide just a single row or column. There are two ways to do so:
You may like these other stories...
With high school teachers having to vie against all things digital to capture their students’ attention, it’s more important than ever for them to use fun and interactive lessons to bring accounting principles to...
Building complex spreadsheets without lookup formulas, such as VLOOKUP, is akin to putting a screw in the wall with a hammer. It’s possible, but the results aren’t pretty, and most probably won’t maintain...
Read more from Michael Alter here and in the Dollars and Sense archive. The noise about using social media as a means to grow your business has become so constant it almost blends into the background at this point. With...
Upcoming CPE Webinars
BAR is an acronym for: Boundaries, Authority and Role. This simple tool will provide participants with a solid understanding of leadership essentials to improve their performance.
This material is designed to provide a start-to-finish overview of how to plan and complete high-quality small audits efficiently.
In this session Excel expert David H. Ringstrom, CPA shares numerous techniques that you can use to work with charts more efficiently.
Key Accounting and Reporting Issues for Nonprofits No. 1: Overview and Statement of Financial Position
This material focuses on non-profit organizations organization, accounting and reporting.