Microsoft® Office Excel® 2007 Plain & Simple

Hiding Rows and Columns

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 scrolling back and forth to access the data you need, you can hide any intervening rows or columns so everything you need to see is displayed on the screen at the same time. The rows you hide are only gone 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 you want to hide.

2. Right-click the selection and choose ...