Working with Rows and Columns
Last updated
Last updated
You can insert new rows and columns, delete some of them, or just hide them and show, when necessary. All these actions are controlled by the Rows and Columns groups of buttons in the View section.
It is possible to insert a new empty row into spreadsheet. A new row is added above the selected one.
To insert an empty row, follow one of the ways below:
Select the row above which you want to insert an empty one - just click on its header.
Click the Rows button in the View section to open a drop-down menu and choose the Insert row option.
Or:
Right-click the header of the row.
Select Insert row in the context menu.
To delete a row, follow one of the ways below:
Select the row you want to delete.
Click the Rows button in the View section to open a drop-down menu and choose the Delete row option.
Or:
Right-click the header of the row.
Select Delete row in the context menu.
The hidden row is marked as a bold line between the headers of the rows above and below:
To hide a row, follow one of the ways below:
Select the row you want to hide by clicking on its header.
Click the Rows button in the View section to open the drop-down menu and choose the Hide row option.
Or:
Right-click the header of the row.
Select Hide row in the context menu.
To show a hidden row, follow one of the ways below:
Select either the row above or below of the hidden one.
Click the Rows button in the View section to open the drop-down menu and choose the Show row option.
Or:
Right-click the row previous to the hidden one or the row that follows it.
Select Show row in the context menu.
You can insert an empty column into spreadsheet. A new column is added to the left of the selected one.
To insert an empty column:
Select the column to the left of which you want to insert an empty one - just click on its header.
Click the Columns button in the View section to open the drop-down menu and select the Insert column option.
Or:
Right-click the header of the column.
Select Insert column in the context menu.
To delete a column:
Select the column you want to delete by clicking on its header.
Click the Columns button in the View section to open the drop-down menu and choose the Delete column option.
Or:
Right-click the header of the column.
Select Delete column in the context menu.
You can hide a column and show it again, when needed. The hidden column is marked as a bold line between the headers of the columns to the left and to the right.
To hide a column, follow one of the ways below:
Select the column you want to hide by clicking on its header.
Click the Columns button in the View section to open the drop-down menu. Choose the Hide column option.
Or:
Right-click the header of the column.
Select Hide column in the context menu.
To show a hidden column, follow one of the ways below:
Select either the column to the left or to the right of the hidden one.
Click the Columns button to open the drop-down menu and choose the Show column option.
Or:
Right-click the column to left or to the right of the hidden one.
Select Show column in the context menu.
It's possible to freeze a row with data in a spreadsheet. This row will remain visible on the screen during vertical scrolling.
To freeze a row:
1) Select the row you want to freeze by clicking its header.
The 3rd row will be frozen
2) Click the Freeze/unfreeze rows button in the View section:
3) Scroll the sheet vertically to see that the selected row will remain in its place, while the rows below will be scrolled up and disappear under the static part of the sheet:
You can freeze a column with data to make it always visible on the screen independently of horizontal scrolling.
To freeze a column:
1) Select the column you want to freeze by clicking its header.
The column C will be frozen
2) Click the Freeze/unfreeze columns button in the View section:
3) Scroll the sheet horizontally to see that the selected column will stay in its place, while the columns to the right will be scrolled to the left and become hidden behind the static part of the sheet:
