Excel shortcuts

15 essential Excel shortcuts for deleting rows and columns

If you're an Excel power user, then you know that deleting rows and columns is a common task. And while you can always use the mouse to do it, there are faster ways to do it using keyboard shortcuts.

Here are 15 essential Excel shortcuts for deleting rows and columns:

  1. Ctrl+- (minus sign): Delete the row or column where your cursor is
  2. Shift+Space: Select the entire row
  3. Ctrl+Space: Select the entire column
  4. Ctrl+Shift+- (minus sign): Delete the row or column where your cursor is, and shift the remaining cells up or left
  5. Ctrl+Shift+Space: Select the entire row or column, and shift the remaining cells up or left
  6. Ctrl+Shift+< (left arrow): Delete the row or column to the left of your cursor
  7. Ctrl+Shift+> (right arrow): Delete the row or column to the right of your cursor
  8. Ctrl+Shift+^ (up arrow): Delete the row above your cursor
  9. Ctrl+Shift+v (down arrow): Delete the row below your cursor
  10. Ctrl+Shift+< (left arrow) then Ctrl+Shift+> (right arrow): Delete the column to the left of your cursor, and shift the remaining columns to the right
  11. Ctrl+Shift+> (right arrow) then Ctrl+Shift+< (left arrow): Delete the column to the right of your cursor, and shift the remaining columns to the left
  12. Ctrl+Shift+^ (up arrow) then Ctrl+Shift+v (down arrow): Delete the row above your cursor, and shift the remaining rows down
  13. Ctrl+Shift+v (down arrow) then Ctrl+Shift+^ (up arrow): Delete the row below your cursor, and shift the remaining rows up
  14. Ctrl+Shift+< (left arrow) then Ctrl+Shift+> (right arrow) then Ctrl+Shift+^ (up arrow): Delete the row or column to the left of your cursor, and shift the remaining cells up or left
  15. Ctrl+Shift+> (right arrow) then Ctrl+Shift+< (left arrow) then Ctrl+Shift+v (down arrow): Delete the row or column to the right of your cursor, and shift the remaining cells down or right

Do you have a favorite Excel shortcut for deleting rows and columns? Share it with us in the comments!

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.