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.

To delete rows:

It's easy to delete any row that you no longer need in your workbook.

  1. Select the row(s) you want to delete. In our example, we'll select rows 6-8.


    Screenshot of Excel 2013Selecting rows to delete
  2. Click the Delete command on the Home tab.


    Screenshot of Excel 2013Clicking the Delete command
  3. The selected row(s) will be deleted, and the rows below will shift up. In our example, rows 9-11 are now rows 6-8.


    Screenshot of Excel 2013Rows 9-11 shifted up to replace rows 6-8

To delete columns:

  1. Select the columns(s) you want to delete. In our example, we'll select column E.


    Screenshot of Excel 2013Selecting a column to delete
  2. Click the Delete command on the Home tab.


    Screenshot of Excel 2013Clicking the Delete command
  3. The selected columns(s) will be deleted, and the columns to the right will shift left. In our example, Column F is now Column E.


    Screenshot of Excel 2013Column F shifted right to replace column E

It's important to understand the difference between deleting a row or column and simply clearing its contents. If you want to remove the content of a row or column without causing others to shift, right-click a heading, then select Clear Contents from the drop-down menu.

Screenshot of Excel 2013Clearing the contents from several rows