# 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LFMCWB0qkCkasX6Ruoa%2Frows_columns_buttons.png?generation=1529397782900467\&alt=media)

## 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKayABBXEbFgKNFW%2Finsert_row.png?generation=1529054861417741\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKb1ezy5se0B4m0g%2Finsert_row_option.png?generation=1529054864743704\&alt=media)

Or:

1. Right-click the header of the row.
2. Select *Insert row* in the context menu.

![Insert Row via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKb3N_tcJf2Cp_f5%2Finsert_row_context_option.png?generation=1529054849766279\&alt=media)

### 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKb5hgvFo9pJ_q8s%2Fdelete_row_option.png?generation=1529397778680522\&alt=media)

Or:

1. Right-click the header of the row.
2. Select *Delete row* in the context menu.

![Delete Row via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKb3N_tcJf2Cp_f5%2Finsert_row_context_option.png?generation=1529054849766279\&alt=media)

### Hiding Rows

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

![Hidden Row](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbAJmZGX2Ev7PhJ%2Fhidden_row.png?generation=1529397776664418\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1qu2PxvWm8jPkBj_1%2Fhide_row_option.png?generation=1529397776502945\&alt=media)

Or:

1. Right-click the header of the row.
2. Select *Hide row* in the context menu.

![Hide Row via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKbFjeDX3sc_cjpG%2Fhide_row_context_option.png?generation=1529054859911665\&alt=media)

### 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMu8I0hD4GRWtAogFP%2F-LF1lKbHKZ_h7Eq20vCv%2Fshow_row_option.png?generation=1529409482589297\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LFMCWBVoZ77Z4Ii_Gz8%2Fshow_row_context_option.png?generation=1529397782796346\&alt=media)

## 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbN7DljR7glFSE6%2Finsert_column.png?generation=1529397779598828\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbP0CdAlUdpunBW%2Finsert_column_option.png?generation=1529397776745948\&alt=media)

Or:

1. Right-click the header of the column.
2. Select *Insert column* in the context menu.

![Insert Column via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbSmaiJdQvN_PDn%2Finsert_column_context_option.png?generation=1529397779070327\&alt=media)

### 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbUkTws1B6T5r2_%2Fdelete_column_option.png?generation=1529397778981885\&alt=media)

Or:

1. Right-click the header of the column.
2. Select *Delete column* in the context menu.

![Delete Column via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbXHq4edId872w7%2Fdelete_column_context_option.png?generation=1529397777520286\&alt=media)

### 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbZAgmH0S_U-Rip%2Fhidden_column.png?generation=1529397778494977\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbaf8AbatUkI7Ce%2Fhide_column_option.png?generation=1529397776671283\&alt=media)

Or:

1. Right-click the header of the column.
2. Select *Hide column* in the context menu.

![Hide Column via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbddk-e2ncYrPbL%2Fhide_column_context_option.png?generation=1529397777487773\&alt=media)

### 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKbfW4xsTEC63W9N%2Fshow_column_option.png?generation=1529397776531170\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LFMCWC3t-tSI_q-PrsS%2Fshow_column_context_option.png?generation=1529397783260062\&alt=media)

## 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKbja_mJ6TyC1Vzr%2Frow_to_freeze.png?generation=1529054864155203\&alt=media)

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

![Freeze/Unfreeze Rows Button](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1lKblHIpIW3W_n26-%2Ffreeze_rows_button.png?generation=1529397778043037\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKbn6q9xmIZI-fd1%2Ffrozen_row.png?generation=1529054866964493\&alt=media)

### 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKbpOjl8RDVvTAc6%2Fcolumn_to_freeze.png?generation=1529054865412773\&alt=media)

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

![Freeze/Unfreeze Columns Button](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMCVPTOz3nXDBYJM7J%2F-LF1qu2pg7Ig84gDaUML%2Ffreeze_columns_button.png?generation=1529397779684451\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKbrczGkUOwJNHrJ%2Ffrozen_column.png?generation=1529054861400085\&alt=media)

## Setting Format for Entire Column/Row

You can set the necessary format for the whole column or row. There are two ways you can choose from.

### Set format via the toolbar

1\) Select the column/row by clicking on its header.

2\) Click the **Number format** button in the **Number** toolbar section and select the format.

### Set format via the context menu

1\) Select the column/row by clicking on its header.

2\) Right-click on the column/row header to open the context menu.

3\) Choose the *Column format* option for a column and select the necessary format:

![Set Column Format via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2Fgit-blob-3062bb91d5750a505d239695611bfaf6ad748772%2Fcolumn_format_context_menu.png?alt=media)

or choose the *Row format* option for a row and select the format for it:

![Set Row Format via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2Fgit-blob-514648ec0e14ac7828a5cdd5705e25e67658b86f%2Frow_format_context_menu.png?alt=media)

### Inheriting columns/rows formats by new cells

When a new column or row is added, new cells inherit the existing formats in the following way:

* on adding a new row/rows, new cells inherit the format from the cells of the above row
* on adding a new column/columns, new cells inherit the format from the cells of the column to the left