» Automatically Defining Names for Ranges in Lists
CATEGORY - Excel Range Name
VERSION - All Microsoft Excel Versions
To automatically define Names according to the labels in the top row's cells and in the left column cell's:1. Select any cell in the data area and select the Current Region by pressing Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A).
2. Press Ctrl+Shift+F3.
OR
From the Insert menu, select Name and then Create.
3. Select the Top row and Left column options, and then click OK.
Each row and column range now defines its own range Name,
for example: the range address for the defined Name January_2004 is $B$2:$B$11, and the range address for the defined Name Income is $B$2:$E$2.
Book Store:
Recommended Books:
- Microsoft Word Version 2002 Inside Out
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Windows XP Inside Out
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
No comments have been submitted.
