Adding and deleting cells

You might need to add a spreadsheet document cell, row, or column, as well as remove rows or columns.

Adding a row (column). Perform the following steps (rows are inserted above the selected row, and columns are inserted to the left of the selected column).

  • Select the number of rows or columns that you want to insert at the location where they are to be inserted.
  • On the main menu, point to Table, point to Cells, and click Insert.

To insert rows, you can do the following: on the main menu, point to Table, point to Cells, and click Insert rows above or Insert rows below.

To insert columns, you can do the following: on the main menu, point to Table, point to Cells, and click Insert columns right or Insert columns left.

Deleting a row (column). To delete a row or a column: 

  • Select rows or columns.
  • On the main menu, point to Edit and click Delete.

To delete selected rows (or columns), you can do the following: on the main menu, point to Table, point to Cells, and click Remove rows or Remove columns.

Rows or columns are deleted with all their contents. They are replaced with rows below or columns to the right.

Inserting a cell. You can insert a cell anywhere in a spreadsheet document.

To insert a cell:

  • Select a cell at the position where you want to insert a new cell.
  • On the main menu, point to Table, point to Cells, and click Insert.
  • Select how to move cells to make room for a new cell: horizontally (move cells to the right) or vertically (move cells down).
  • Click OK.

Inserting a cell range. You can insert a cell range to a spreadsheet document.

To insert a cell range:

  • Select the cell range of the same size at the position where you want to insert a cell range.
  • On the main menu, point to Table, point to Cells, and click Insert.
  • Select how to move cells to make room for a new range: horizontally (move cells to the right) or vertically (move cells down).
  • Click OK.

Deleting a cell range. To delete a cell range:

  • Select a cell range.
  • On the main menu, point to Edit and click Delete.
  • Select how to move cells to replace the deleted range: horizontally (move cells to the left) or vertically (move cells up).
  • Click ОK.
Next page: Splitting cells

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.