This shortcut will select cells in the whole worksheet if it is empty. If it contains information the shortcut will select the region that contains information except summary rows.

Use the shortcut once again and all fields with information including summary rows will be selected. A final use of the shortcut will select the whole Excel worksheet.

Select cells containing data or the whole sheet

Categories: Select

Leave a Reply

Your email address will not be published. Required fields are marked *