Microsoft Office Tutorials and References
In Depth Information
Hiding and unhiding columns and rows
hiding and unhiding columns and rows
If you’re working with a worksheet that contains lots of data,
you might need to refer to the contents of rows or columns that
aren’t close enough on the worksheet to appear on the same
screen. Rather than scroll back and forth to access the data that
you need, you can hide any intervening rows or columns so that
everything that you need to see is displayed on the screen at
the same time. The rows or columns that you hide are gone only
temporarily. The data hasn’t been deleted; it’s just been moved
out of your way while you don’t need it.
hide rows or columns
1 Select the rows or columns that you want to hide.
Right-click a row or column header in the selection, and choose
Hide from the shortcut menu.