» Quickly Selecting a Range in the Workbook
CATEGORY - Excel Worksheet, Workbook
VERSION - All Microsoft Excel Versions
The best way to select a cell or range of cells in either the current or any other sheet in the workbook is by selecting the Name defined for that range from the Name Box dropdown list to the left of the Formula Bar.
The Name Box contains a list of the Names assigned to the cell addresses. Selecting a Name is the same as selecting the address of a cell or range of cells in the active workbook.
Book Store:
Recommended Books:
- Learn MS Excel 2002 VBA/XML Programming
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Guide to Financial Reporting and Analysis
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- The 22 Immutable Laws of Branding
No comments have been submitted.
