Tricks for Hiding and Unhiding Excel Rows and Columns

  • 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.
 
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:
  • 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.
Windows XP:
  • No Control Panel changes are necessary.
Unhide Selectively
 
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...

Regulatory compliance, risk management and cost-cutting are the big heartburn issues for finance execs in the C-suite. Yet financial planning and analysis—a key antacid—is insufficient.That's just one of the...
Continuing its efforts to simplify accounting procedures, the FASB has issued a proposed Accounting Standards Update on customer fees paid in a cloud computing arrangement. The newly-proposed update (Intangibles—...
How are you planning? What tools do you use (or fail to use) for forecasting? PlanGuru is a business budgeting, forecasting, and performance review software company based in White Plains, N.Y. AccountingWEB recently spoke...

Already a member? log in here.

Upcoming CPE Webinars

Sep 9
In this session we'll discuss the types of technologies and their uses in a small accounting firm office.
Sep 10
Transfer your knowledge and experience to prepare your team for the challenges and opportunities of an accounting career.
Sep 11
This webcast will include discussions of commonly-applicable Clarified Auditing Standards for audits of non-public, non-governmental entities.
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.
Looking for AccountingWEB UK?