> 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](/files/-LaQQTc6NT_lyFAK8EBJ)

## 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](/files/-LaQS9mNav8cKCxK34iF)

## 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](/files/-LaQTxjF4TvGvbSHH64N)

## 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](/files/-LaQV5MK3RJcUG9hT8PO)

##