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:
- Ctrl+- (minus sign): Delete the row or column where your cursor is
- Shift+Space: Select the entire row
- Ctrl+Space: Select the entire column
- Ctrl+Shift+- (minus sign): Delete the row or column where your cursor is, and shift the remaining cells up or left
- Ctrl+Shift+Space: Select the entire row or column, and shift the remaining cells up or left
- Ctrl+Shift+< (left arrow): Delete the row or column to the left of your cursor
- Ctrl+Shift+> (right arrow): Delete the row or column to the right of your cursor
- Ctrl+Shift+^ (up arrow): Delete the row above your cursor
- Ctrl+Shift+v (down arrow): Delete the row below your cursor
- 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
- 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
- Ctrl+Shift+^ (up arrow) then Ctrl+Shift+v (down arrow): Delete the row above your cursor, and shift the remaining rows down
- Ctrl+Shift+v (down arrow) then Ctrl+Shift+^ (up arrow): Delete the row below your cursor, and shift the remaining rows up
- 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
- 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!