Spreadsheet User Guide
  • Introduction
  • Hot Keys List
  • Work with Cells
  • Work with Rows and Columns
  • Data Formatting
  • Number Formatting
  • Excel Import/Export
Powered by GitBook
On this page
  • Adding rows
  • Removing rows
  • Adding columns
  • Removing columns

Was this helpful?

Work with Rows and Columns

PreviousWork with CellsNextData Formatting

Last updated 6 years ago

Was this helpful?

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

Note that a new row will be added above the selected one.

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

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

Note that a new column will be added to the left of the selected one.

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

Adding rows
Removing rows
Adding columns
Removing columns