> For the complete documentation index, see [llms.txt](https://dhtmlx-docs.gitbook.io/spreadsheet-user-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dhtmlx-docs.gitbook.io/spreadsheet-user-guide/work-with-rows-and-columns.md).

# Work with Rows and Columns

dhtmlxSpreadSheet allows adding and removing columns and rows into a sheet via both toolbar buttons and options of the context menu.

## Adding rows

To add a new row, take the following steps:

1. Select a row by clicking on its header. 
2. Choose one of the two actions:

* click the **Add row** button in the toolbar 
* or right-click the row and choose *Rows-> Add row*

{% hint style="info" %}
Note that a new row will be added above the selected one.
{% endhint %}

![Adding rows](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaQE-0fuD42PHnNB5V0%2F-LaQQTc6NT_lyFAK8EBJ%2Fadding_rows.gif?alt=media\&token=a063c63c-4a91-4408-b23e-eadcec022107)

## Removing rows

To remove a row, take the following steps:

1. Select a row by clicking on its header. 
2. Choose one of the two actions:

* click the **Remove row** button in the toolbar 
* or right-click the row and choose *Rows-> Remove row*

![Removing rows](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaQE-0fuD42PHnNB5V0%2F-LaQS9mNav8cKCxK34iF%2Fremoving_rows.gif?alt=media\&token=0296ef85-460f-477a-a200-9f3949fea193)

## Adding columns

To add a new column, take the following steps:

1. Select a column by clicking on its header. 
2. Choose one of the two actions:

* click the **Add column** button in the toolbar 
* or right-click the column and choose Columns*-> Add column*

{% hint style="info" %}
Note that a new column will be added to the left of the selected one.
{% endhint %}

![Adding columns](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaQE-0fuD42PHnNB5V0%2F-LaQTxjF4TvGvbSHH64N%2Fadding_columns.gif?alt=media\&token=55a9f735-f9bc-4d24-9624-8970d769d035)

## Removing columns

To remove a column, take the following steps:

1. Select a column by clicking on its header. 
2. Choose one of the two actions:

* click the **Remove column** button in the toolbar 
* or right-click the column and choose *Columns-> Remove column*

![Removing columns](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaQE-0fuD42PHnNB5V0%2F-LaQV5MK3RJcUG9hT8PO%2Fremoving_columns.gif?alt=media\&token=56c8807b-b786-42f2-9014-c8cf7b44db93)

##