CTRL + Shift + *

One of the more common and useful keyboard commands is the CTRL + Shift + * key combination.
This 3 key combination will select the current region around active cells (all the data encompassed by blank rows and blank columns).

To help you identify selected cells, Excel will display them darker than unselected cells.

No comments:

Post a Comment