Ctrl+Space Bar: Select Column in Excel; Shift+Space Bar: Select Row in Excel

In Excel, hit Ctrl plus the Space Bar to select the entire column of your active or selected cells. (Then you can delete all the cell contents with the delete key, or copy with Ctrl+C or whatever you like.)

Similarly, Shift plus the Space Bar selects the entire row of cells.

For example, suppose you want to move a column. Follow these steps:

  1. Move your cursor to some cell in the column you want to move. (Remember you can press F5 to instantly go anywhere.)
  2. Press Ctrl+Space Bar. The entire column is selected.
  3. Press Ctrl+X to Cut the column.
  4. Move your cursor to the location right where you want the column inserted.
  5. Press Shift+F10 to display the shortcut menu.
  6. Using the arrow keys and Enter, select the Insert Cut Cells command.

One thought on “Ctrl+Space Bar: Select Column in Excel; Shift+Space Bar: Select Row in Excel”

  1. I HATE this feature – I’m forever typing Shift Space – then the WHOLE row gets put into a formula and it’s not even correct syntax. PLEASE can I turn this off!!

Leave a Reply

Your email address will not be published. Required fields are marked *