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.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments