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 that 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.
Click the row or column header of the row above or the column to the left of the rows or columns you want to unhide.
Hold down the Shift key and click the row or column header of the row or column below or to the right of the rows or columns you want to unhide.
Right-click the selection and choose Unhide from the shortcut menu.
There are two ways you can tell that hidden rows or columns are in a worksheet. First, whenever rows or columns are hidden, there will be row numbers or column letters missing. For example, if rows 2, 3, and 4 are hidden, the first two visible rows of the worksheet will be labeled row 1 and row 5.
The other way you can tell that a worksheet contains hidden rows or columns is that a thick line will appear on the border of the row header or column header where the rows or columns would otherwise appear.
3.143.17.27