How to select an entire column in Excel
By
SpreadCheaters
Page last updated:
16/11/2022 |
Next review date:
16/11/2024
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
