Excel shortcuts

15 Keyboard Shortcuts for Deleting Rows and Columns in Excel

Deleting rows and columns is a common task in Excel, and there are a few different ways to do it. The most common way is to select the row or column you want to delete and then press the delete key. However, there are a few keyboard shortcuts that can make this task even easier.

To delete a row, first select the row you want to delete. Then, press the following keys:

  • Ctrl + -

To delete a column, first select the column you want to delete. Then, press the following keys:

  • Ctrl + Shift + -

If you want to delete multiple rows or columns at once, you can select multiple rows or columns by holding down the Shift key while you click on the row or column headers. Then, you can use the same keyboard shortcuts as above to delete the selected rows or columns.

Here are a few more keyboard shortcuts that can be useful when deleting rows and columns:

  • Ctrl + Y: Delete the selected cells
  • Ctrl + Shift + Y: Delete the selected rows
  • Ctrl + Shift + X: Delete the selected columns

Remember, you can always Undo any changes you make by pressing the Ctrl + Z keys.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.