Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

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.

webmaster@allaboutoffice.co.uk