Working with Rows and Columns

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.

Rows and Columns Buttons

Working with Rows

Inserting Rows

It is possible to insert a new empty row into spreadsheet. A new row is added above the selected one.

Inserting Rows

To insert an empty row, follow one of the ways below:

  1. Select the row above which you want to insert an empty one - just click on its header.

  2. Click the Rows button in the View section to open a drop-down menu and choose the Insert row option.

Insert Row via Rows Button

Or:

  1. Right-click the header of the row.

  2. Select Insert row in the context menu.

Insert Row via Context Menu

Deleting Rows

To delete a row, follow one of the ways below:

  1. Select the row you want to delete.

  2. Click the Rows button in the View section to open a drop-down menu and choose the Delete row option.

Delete Row via Rows Button

Or:

  1. Right-click the header of the row.

  2. Select Delete row in the context menu.

Delete Row via Context Menu

Hiding Rows

The hidden row is marked as a bold line between the headers of the rows above and below:

Hidden Row

To hide a row, follow one of the ways below:

  1. Select the row you want to hide by clicking on its header.

  2. Click the Rows button in the View section to open the drop-down menu and choose the Hide row option.

Hide Row via Rows Button

Or:

  1. Right-click the header of the row.

  2. Select Hide row in the context menu.

Hide Row via Context Menu

Showing Rows

To show a hidden row, follow one of the ways below:

  1. Select either the row above or below of the hidden one.

  2. Click the Rows button in the View section to open the drop-down menu and choose the Show row option.

Show Row via Rows Button

Or:

  1. Right-click the row previous to the hidden one or the row that follows it.

  2. Select Show row in the context menu.

Show Row via Context Menu

Working with Columns

Inserting Columns

You can insert an empty column into spreadsheet. A new column is added to the left of the selected one.

Inserting Columns

To insert an empty column:

  1. Select the column to the left of which you want to insert an empty one - just click on its header.

  2. Click the Columns button in the View section to open the drop-down menu and select the Insert column option.

Insert Column via Columns Button

Or:

  1. Right-click the header of the column.

  2. Select Insert column in the context menu.

Insert Column via Context Menu

Deleting Columns

To delete a column:

  1. Select the column you want to delete by clicking on its header.

  2. Click the Columns button in the View section to open the drop-down menu and choose the Delete column option.

Delete Column via Columns Button

Or:

  1. Right-click the header of the column.

  2. Select Delete column in the context menu.

Delete Column via Context Menu

Hiding Columns

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.

Hidden Column

To hide a column, follow one of the ways below:

  1. Select the column you want to hide by clicking on its header.

  2. Click the Columns button in the View section to open the drop-down menu. Choose the Hide column option.

Hide Column via Columns Button

Or:

  1. Right-click the header of the column.

  2. Select Hide column in the context menu.

Hide Column via Context Menu

Showing Columns

To show a hidden column, follow one of the ways below:

  1. Select either the column to the left or to the right of the hidden one.

  2. Click the Columns button to open the drop-down menu and choose the Show column option.

Show Column via Columns Button

Or:

  1. Right-click the column to left or to the right of the hidden one.

  2. Select Show column in the context menu.

Show Column via Context Menu

Frozen Columns and Rows

Freezing Rows

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

Selecting a Row to Freeze

2) Click the Freeze/unfreeze rows button in the View section:

Freeze/Unfreeze Rows Button

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:

Frozen Row

Freezing Columns

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

Selecting a Column to Freeze

2) Click the Freeze/unfreeze columns button in the View section:

Freeze/Unfreeze Columns Button

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:

Frozen Column