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

Ctrl + A

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.


Please send us your comments on this article.

Inline Feedbacks
View all comments