How to select an entire column in Excel

You can watch a video tutorial here.

The format of a spreadsheet in Excel is in the form of columns and rows. You may need to select an entire column to format it or copy it to another location.

Option 1 – Select the cell header

– Place the cursor on the column header
– When the cursor changes to a small black arrow, click
– The entire column will be selected

Option 2 – Select a cell in the column

– Place the cursor in any cell in the column to be selected
– Press Ctrl+Spacebar or Ctrl+Shift+Down Arrow
– The column will be selected