Many ways to delete rows and columns in Excel | how to delete column in excel ?

Learn how to delete row and column in excel

You can use keyboard  shortcut keys to delete rows or columns in Excel, or even delete them with the mouse.

To delete a row, select the row you want to delete in Excel. Right-click on the row with the numbers on the left side of the seat and click on Delete Row. Row will be given.

30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

Similarly, to delete a column, select the column name (eg A, B, C, D). And right click with the mouse and click on delete option.

Many ways to delete rows and columns in Excel | how to delete column in excel ?

Let us now see how to delete rows and columns in excel using shortcut keys.

Use the shortcut key  Shift  + Space to select the entire row of selected cells. And use the shortcut CTRL + minus sign (-) to Delete the selected row. All selected rows will be deleted immediately. 

how to delete column in excel

how to delete column in excel

Similarly, use the shortcut CTRL + Space to select the entire column of the selected cell. Ctrl + minus sign (-) is also used to delete the selected column.

how to delete column in excel

how to delete column in excel

5 Important Excel Shortcut Keys That Make You An Expert In MS Excel Select, Insert or Delete Row or Column

Leave a Comment