but can still be selected for copying if you select the elements around them. For example, if column B is hidden, it is copied when you select columns A and C. When you need a hidden element again, you can reverse the process, and show the element. • To hide or show rows and columns, use the option in the Format menu or the right-click and choose from pop- up menu.
• To hide a row/column, first select the row/column, and then use menu options, • Format → Row → Hide or Format → Column → Hide to hide row and column respectively. • The same can be achieved by choosing “Hide” option from the pop-up menu when you right-click the selected row/column. • To show the hidden row / column, choose Format → Row → Show or Format → Column → Show (or) • Right-click and choose Show from pop-up menu. .
- Freezing and Unfreezing rows and columns Freezing locks number of rows at the top of a spreadsheet or number of columns on the left of a spreadsheet or both. Frozen columns and rows remain in view during scrolling, whereas other rows and columns gets scrolled. Figure . Freezing and Unfreezing rows and columns Freezing single rows or columns: .
Click on the Header for the row below where to the freeze or for the column to the right of where to freeze. . Choose the Window -> Freeze . A dark line appears, indicating where the freeze is done.
Freezing a row and a column: . Click the Cell that is immediately below the row to be frozen and immediately to the right of the column to be frozen. . Choose Window -> Freeze .
. Two lines appear on the screen, a horizontal line above this cell and a vertical line to the left of this cell. Now as you scroll around the screen, everything above and to the left of these lines will remain in view. Unfreeze: To unfreeze rows or columns, choose Window -> Freeze .
The check mark in Freeze will