Excel Hack

Excel shortcut to select all data

If you have to use the mouse to scroll through a spreadsheet when selecting large data with hundreds of rows, you will lose a lot of time. With the shortcut keys described here, you can select all the data with a single keystroke. There are several shortcut keys for selecting all data, so please use the one that best suits your needs.

Shortcut to select all data

Windows
Ctrl + A

Mac
command + A or control + A

How to select all data

This is a way to select all data using shortcut keys.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell with the data.

Select all data

select all data

Press Ctrl + A to select all data. Note, however, that if there are blank rows or columns in the data range, only the immediately preceding data will be selected.