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.
Right-click the selection and choose Hide from the shortcut menu.
You can tell that there are hidden rows or columns in a worksheet in two ways. First, whenever rows or columns are hidden, row numbers or column letters will be missing. For example, if rows 2 through 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.141.199.56