Topics

Apr 10, 2011

Select unnamed cells or ranges using the Name box in Excel 2007

To select unnamed cells or ranges using the Name box, do the following:
Selecting a single cell: Click the Name box and type the cell reference and press the ENTER key. For example: if you type B4 and press the ENTER key, cell B4 will be selected.
Selecting a range of cells: Click the Name box and type the cell reference for the range and press the ENTER key. For example: if you type C2:C10 and press the ENTER key, cells C2 to C10 will be selected.

0 comments:

Post a Comment