Modifying Columns, Rows, and Cells

In Excel column width can be modified, as can row height and width in Excel. Learn to modify Excel cells in this free Excel 2016 lesson.

Inserting, deleting, moving, and hiding rows and columns

After you've been working with a workbook for a while, you may find that you want to insert new columns or rows, delete certain rows or columns, move them to a different location in the worksheet, or even hide them.

To insert rows:

  1. Select the row heading below where you want the new row to appear. For example, if you want to insert a row between rows 7 and 8, select row 8.
    Screenshot of Excel 2013Selecting a row
  2. Click the Insert command on the Home tab.


    Screenshot of Excel 2013Clicking the Insert command
  3. The new row will appear above the selected row.


    Screenshot of Excel 2013The new row

When inserting new rows, columns, or cells, you will see the Insert Options button Cursor next to the inserted cells. This button allows you to choose how Excel formats these cells. By default, Excel formats inserted rows with the same formatting as the cells in the row above. To access more options, hover your mouse over the Insert Options button, then click the drop-down arrow.

Screenshot of Excel 2013The Insert Options button

To insert columns:

  1. Select the column heading to the right of where you want the new column to appear. For example, if you want to insert a column between columns D and E, select column E.


    Screenshot of Excel 2013Selecting a column
  2. Click the Insert command on the Home tab.


    Screenshot of Excel 2013Clicking the Insert command
  3. The new column will appear to the left of the selected column.


    Screenshot of Excel 2013The new column

When inserting rows and columns, make sure you select the entire row or column by clicking the heading. If you select only a cell in the row or column, the Insert command will only insert a new cell.