Hiding Columns and Rows
To hide a column or row you first need to select the column or row by
clicking on the letter at the top of the column or the number to the left of the
row to select it. You can select a
range of columns or rows at once by highlighting several of the row or column
labels together. When you have done
this, click on the Format drop-down menu and choose Hide or click
your right mouse button over the highlighted range and choose Hide from
the menu that appears as below.
You now cannot see the hidden row
but you are aware that it exists because the row number is missing on the left
as shown below.
When you want to unhide a row or
column you have to select the rows or columns on either side or place your
cursor in the hidden row or column. As
there is no row above the first row that we have hidden, we have to use the Go
To function to move to the first row and then unhide it (this also works for
any row or column). To unhide the
first row, click on the Edit drop-down menu and choose Go To
or press CTRL and G together, a window appears as below.
Type the cell reference A1 (or any
reference on the row or column you have hidden) and click OK, your cursor
is now on that row or column. Click
on the Format drop-down menu and choose Row or Column and
then Unhide, your hidden row or column will now reappear.
To protect others from unhiding your hidden details you need to protect
your workbook or worksheet, this is covered later.
To quickly unhide all rows, including a hidden first row, you can click
the plain grey square at the top left corner of the worksheet where the column
letters and row numbers intersect, this will select the whole worksheet.
Now click on the Format drop-down menu and choose Row (or Column)
and then Unhide, all your data should now be visible.
Click here to
return to the Excel index.