Select Entire Rows in a Worksheet

Use Shortcut Keys to Select Rows Use Shortcut Keys to Select Additional Rows Use the Mouse to Select Rows Use the Mouse to Select Additional Rows

Select Entire Columns in a Worksheet

Use Shortcut Keys to Select Columns Use Shortcut Keys to Select Additional Columns To select additional columns on either side of the selected column: Use the Mouse to Select Columns Use the Mouse to Select Additional Columns

Select All Cells in a Worksheet

Use Shortcut Keys to Select All Cells Use ‘Select All’ to Select All Cells If you prefer not to use the keyboard, use Select All to 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.

Select All Cells in a Table

Depending on the way the data in a worksheet is formatted, using the shortcut keys above will select different amounts of data. If the active cell is located within a contiguous range of data:

Press Ctrl+A to select all the cells containing data in the range.

If the data range has been formatted as a table and has a heading row that contains drop-down menus:

Press Ctrl+A a second time to select the heading row.

The selected area can then be extended to include all cells in a worksheet.

Press Ctrl+A a third time to select the entire worksheet.

Select Multiple Worksheets

Not only is it possible to move between sheets in a workbook using a keyboard shortcut, but you can also select multiple adjacent sheets with a keyboard shortcut as well. Simply add the Shift key to the key combinations above. To select pages to the left: To select pages to the right:

Selecte Multiple Sheets

Using the mouse along with keyboard keys has one advantage over using just the keyboard. It allows you to select non-adjacent sheets as well as adjacent ones. Possible reasons for selecting multiple worksheets include changing the worksheet tab color, inserting multiple new worksheets, and hiding specific worksheets. Select Multiple Adjacent Sheets Select Multiple Non-Adjacent Sheets