TheExcelAddict.com
Microsoft Excel "Quick Tips"

Hiding Rows (Keyboard Method)

I always stress the importance of knowing both a keyboard method and a mouse method for doing most things in Excel. Here are a couple of keyboard shortcuts that will help you save some time.

  • To hide rows, select a cell(s) in the row(s) you want to hide and press CTRL+9.

  • To unhide rows, select a range of cells to the top and bottom of the hidden row(s) and press CTRL+SHIFT+9.


Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool t-shirt.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright 2002 All Rights Reserved by FJH Marketing

Close this window