You can add additional or remove rows or columns in an Excel spreadsheet.
In this article, you will learn the steps to insert and delete rows and columns in an Excel worksheet.
In a worksheet, click the row header where you want to insert a row.
Example shown here: Click row header 17 .
The selected row is highlighted.
To insert a row at the selected location, click the dropdown arrow to the right of the Insert button on the Home tab.
Click the Insert Sheet Rows option.
A new row is inserted at the designated location.
Next, select the column header where you want to insert a column in the worksheet.
Example shown here: Click column header M .
To insert a column at the selected location, click the dropdown arrow to the right of the Insert button.
Click the Insert Sheet Columns option.
A new column is inserted at the designated location.
You can also delete a row or column.
Within an Excel worksheet, click to select the appropriate row(s) or column(s) you would like to delete.
Example shown here: Click row header 18 .
To delete the row, click the dropdown arrow to the right of the Delete button on the Home tab.
Click the Delete Sheet Rows link.
The selected row is deleted.
To delete a column in your worksheet, click in the appropriate column header.
Example shown here: Click column header AS.
The selected column is highlighted.
Repeat the same steps by clicking the dropdown arrow to the right of the Delete button.
Click the Delete Sheet Columns link.
The selected column is deleted.