Editing rows/columns

Manage cells, rows, and columns

You can insert blank cells above or on the left of the selected cell in a worksheet. You can also insert an entire row above the selected one or a column on the left of the selected column. To make it easy to view a large amount of information, you can hide some rows or columns and display them again. It's also possible to specify the height of a certain row and width of a column.

Insert cells, rows, columns

To insert a blank cell to the left of the selected cell:

  1. Right-click the cell to the left of which you wish to insert a new one,

  2. Click the Insert cells icon situated at the Home tab of the top toolbar or select the Insert item from the right-click menu and use the Shift Cells Right option.

The program will shift the selected cell to the right to insert a blank one.

To insert a blank cell above the selected cell:

  1. Right-click the cell above which you wish to insert a new one,

  2. Click the Insert cells icon situated on the Home tab of the top toolbar or select the Insert item from the right-click menu and use the Shift Cells Down option.

The program will shift the selected cell down to insert a blank one.

To insert an entire row:

  1. select either the whole row by clicking its heading or a cell in the row above which you wish to insert a new one,

    Note: To insert multiple rows, select the required number of rows.

  1. click the Insert cells icon situated on the Home tab tab of the top toolbar and use the Entire row option,
    or right-click the selected cell, select the Insert item from the right-click menu, then choose the Entire Row option,
    or right-click the selected row(s) and use the Insert Top option from the right-click menu.

The program will shift the selected row down to insert a blank one.

To insert an entire column:

  1. Select either the whole column by clicking its heading or a cell in the column to the left of which you wish to insert a new one,

    Note: To insert multiple columns, select the required number of columns.

  1. Click the Insert cells icon situated on the Home tab tab of the top toolbar and use the Entire column option,
    or right-click the selected cell, select the Insert item from the right-click menu, then choose the Entire Column option,
    or right-click the selected column(s) and use the Insert Left option from the right-click menu.

The program will shift the selected column to the right to insert a blank one.

You can also use the Ctrl+Shift+= keyboard shortcut to open the dialog box for inserting new cells, select the Shift Cells Right, Shift Cells Down, Entire Row, or Entire Column option and click OK.

Hide and show rows and columns

To hide a row or column:

  1. Select rows or columns you wish to hide,

  2. Right-click the selected rows or columns and use the Hide option from the right-click menu.

To display the hidden rows or columns, select the visible rows above and below the hidden rows or visible columns to the left and to the right of the hidden columns, right-click them and use the Show option from the right-click menu.