Microsoft Excel Tutorial - How to delete columns and Rows

Delete Columns and Rows

Introduction:

You can delete rows and columns just as easily as you can add them. For example, you may find you no longer need a particular row or column of data in a range. You could delete the data and then move the remaining data to close the empty space. It's faster, however, to delete the entire row or column because the Excel closes up the empty space for you.

Step 1: Select the Row

To delete a row, select the row you want to delete (click its row number to select it).

Step 2: Delete the Selected Row

Right-click the selection and select Delete on the shortcut menu.

Step 3: The Row Is Removed

Excel immediately deletes the entire row, and the existing rows move up to fill its place.

Step 4: Select the Column

To delete a column, select the column you want to delete (click its column letter to select it).

Step 5: Deleted the Selected Column

Right-click the selected column and select Delete on the shortcut menu. As soon as you select the command, the column is immediately deleted.

Step 6: Delete Multiple Rows

To delete several adjacent rows all at the same time, select the adjacent rows in the worksheet, right-click the selection, and choose Delete from the shortcut menu.

Step 7: Delete Multiple Columns

To delete several adjacent columns at the same time, select the adjacent columns in the table, right-click the selection, and choose Delete from the shortcut menu.

Tutorials - Microsoft Excel

Other Services Available

Useful Information