Learn › Excel › Select all (table or sheet)

Excel select all shortcut: Ctrl + A

Select your whole table with one press, and the whole sheet with a second press.

← All Excel shortcuts

With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.

WindowsCtrl+A
Mac⌘+A

Keys on keyboards of other languages

The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.

English (US)Ctrl+A
HrvatskiCtrl+A
DeutschStrg+A
EspañolCtrl+A
FrançaisCtrl+A
PortuguêsCtrl+A
ItalianoCtrl+A
TürkçeCtrl+A
Bahasa IndonesiaCtrl+A
PolskiCtrl+A

What it does

Ctrl + A selects all the connected data around the active cell, which is your whole table. Press it a second time and Excel selects the entire sheet, every cell from A1 to the last column and row.

When to use it

Use it to copy a whole table, to change the font of everything, or to clear a sheet. Because the first press selects only your data, it is a quick way to select a table before you copy or format it.

How to do it

  1. Click any cell inside your table.
  2. Press Ctrl + A (on a Mac: Command + A). The whole table is selected.
  3. Press Ctrl + A again to select the entire sheet.
Good to know: The table must be one connected block, with no empty row or column through the middle. If there is a gap, the first press selects only the part around your cell. You can also click the small triangle in the top left corner of the sheet, where the row numbers meet the column letters, to select everything in one click.

A quick example

In the orders table, click the Region cell B4 and press Ctrl + A: the whole table, A1 to D11, is selected. Press Ctrl + A again and the whole sheet is selected, down to the last row and column.

Ctrl + A, Ctrl + Space and Shift + Space

Ctrl + A selects a table or the whole sheet, Ctrl + Space selects one column and Shift + Space selects one row. To select only a column of data, down to the last filled cell, click its first cell and press Ctrl + Shift + Down arrow.

Not working? Check this

  • Nothing happens: click into the sheet first, not into the formula bar or a search box. If you are editing a cell, Ctrl + A selects the text inside that cell instead.
  • The first press selects only part of your data: there is an empty row or column inside it. Fill the gap, or select the range with Shift and the arrow keys.
  • Everything is selected and you wanted only the table: press Escape or click one cell, then press Ctrl + A just once.
  • On a Mac use Command + A.

Quick answers

What is the shortcut to select all in Excel?

Press Ctrl + A. The first press selects your table, the second press selects the whole sheet. On a Mac use Command + A.

How do I select a whole table in Excel?

Click any cell in the table and press Ctrl + A once. The table must be one connected block, without empty rows or columns in the middle.

How do I select the whole sheet?

Press Ctrl + A twice, or click the small triangle in the top left corner of the sheet, where the row numbers meet the column letters.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games