Templates Services SQL Reports Excel Shortcuts Blog About Contact
⌨ Excel Shortcut Guide

Select entire column Shortcut in Excel

Use this quick reference to learn the Windows shortcut, Mac shortcut, Ribbon path, and best use case for select entire column in Excel.

Shortcut keys

WindowsCtrl + Space
MacCtrl + Space

Ribbon path

No menu path — keyboard only

What it does

Selects every cell in the active column. Combine with Shift to extend the selection across multiple columns.

How to use this shortcut

  1. Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
  2. Press the shortcut keys shown above for your platform.
  3. Confirm any dialog options if Excel opens a menu or prompt.

FAQ

What is the Excel shortcut for select entire column?

On Windows, use Ctrl + Space. On Mac, use Ctrl + Space.

Where is select entire column in the Excel Ribbon?

The Ribbon path is No menu path — keyboard only.

What does select entire column do in Excel?

Selects every cell in the active column. Combine with Shift to extend the selection across multiple columns.