Step1: Select a row or column on each side of the hidden rows or columns you want to display.
Step2: On the Format menu, point to Row or Column, and then click Unhide.
Step2: On the Format menu, point to Row or Column, and then click Unhide.
How to Hide a row or column
1. Select the rows or columns you want to hide.
2. On the Format menu, point to Row or Column, and then click Hide.
--------------------
Notes:
To select Text in a cell:
If editing in a cell is turned on, select the cell, double-click in it, and then select the text in the cell.
If editing in a cell is turned off, select the cell, and then select the text in the formula bar.
To select a single cell:
If editing in a cell is turned off, select the cell, and then select the text in the formula bar.
To select a single cell:
Click the cell, or press the arrow keys to move to the cell.
To select a range of cells:
Click the first cell of the range, and then drag to the last cell.
To select a large range of cells:
Click the first cell in the range, and then hold down SHIFT and click the last cell in the range. You can scroll to make the last cell visible.
To select all cells on a worksheet: Click the Select All button.
To select nonadjacent cells or cell ranges:
Select the first cell or range of cells, and then hold down CTRL and select the other cells or ranges.
To select an entire row or column: Click the row or column heading.
To select adjacent rows or columns:
Drag across the row or column headings. Or select the first row or column; then hold down SHIFT and select the last row or column.
To select nonadjacent rows or columns:
Select the first row or column, and then hold down CTRL and select the other rows or columns.
To select more or fewer cells than the active selection: Hold down SHIFT and click the last cell you want to include in the new selection. The rectangular range between the active cell and the cell you click becomes the new selection.
To Cancel a selection of cells: Click any cell on the worksheet.
No comments:
Post a Comment