Find The Limits Of A Selected Range

/, Keyboard/ Find The Limits Of A Selected Range

Find the limits of a selected range

Keyboard shorcuts Ctrl + . and Ctrl + *

By Neale Blackwood
You can use Ctrl + * as a shortcut to selecting what’s called, the current region. This includes all the cells with content around your active cell. If there are blank rows or columns around the area, Excel will not extend the selected range past those rows or columns. This is great for selecting large tables.

Having selected the range you may want to see the limits of that range. You can use Ctrl + . (hold the Ctrl key and press the full stop key) each time you press the full stop key you will go to another corner of the selected range. This enables you to see how large the selected range is, before you do something to it. You can confirm that all the cells you wanted are included.

2017-03-08T03:54:01+00:00Data Handling, Keyboard|