|  

» Selecting the Current Region/List

Using keyboard shortcuts

The Current Region/List is a range of cells containing data bounded by blank rows and columns.
To select the Current Region/List:

• Select a cell inside the Current Region/List range and press Ctrl+Shift+* (when using the * on the numeric keypad, press Ctrl+*).
• New keyboard shortcut in Excel 2003: Select a cell inside the Current Region/List and press Ctrl+A (you can still use Ctrl+Shift+*).



Rate This Tip
12 34 5
Rating: 3.18     Views: 51561
correction
Posted on: 31-12-1969
The asterisxk (*) lives above the 8 on my keyboard. Probably on yours too.
*
Bill  Posted on: 31-12-1969
Press Ctrl+* - above the 9 in the numeric pad or press Ctrl+Shift+* - the number 8 on the keboard
Name
Comment Title
Comments