Question

write the shortcut key to quickly select the entire range of cells.​

Answer 1

Using Shortcut Keys to Select All Cells in a Worksheet

Click on a blank area of a worksheet — an area that contains no data in the surrounding cells.

Press and hold down the Ctrl key on the keyboard.

Press and release the letter A key on the keyboard.

Release the Ctrl key.

Ctrl + A

Select All Cells in a Worksheet using 'Select All'

For those who prefer not to use the keyboard, the Select All button is another option for quickly select all cells in a worksheet.

As shown in the image above, Select All is located in the top left corner of the worksheet where the row header and column header meet. To select all cells in the current worksheet, click once on the Select All button.