Your boss, I. Juan Itnow, calls you into his office to discuss the company's
financial data from the previous quarter. You enter to see the Excel
spreadsheet you created for Mr. Itnow open on his computer screen. Mr.
Itnow proceeds to wave and point around on the screen saying that it is
impossible to figure out where you came up with these totals. You click on
one of the total cells and look in the formula bar. In the formula bar,
there is a sum formula that contains a slew of cell references, and you start
showing Mr. Itnow how to match up the references with the cells on the
spreadsheet. Mr. Itnow, not knowing much about Excel, exclaims, "This
is ridiculous! I don't have time to figure all of this out - I'm a busy
man! Can't you make this easier?" You calmly state, "Why
certainly. I'll have it for you by the end of the day."
After rushing nervously back to your desk, you immediately logon to the Internet
and find the answer here - you need to
create named ranges.
What is a Named Range?
A named range gives a range of cells an actual
text name that can be used to quickly view a group of cells. Named ranges
can also be used in formulas to save time and are much more meaningful.
For
example, if you want to make a total of revenue generated in four quarters of a
fiscal year, it may be easier to type:
=SUM(Quarter1:Quarter4)
Actual cell
references would not need to be looked up, and the formula is more meaningful
when returning to the worksheet for review. This is especially helpful for
working with large workbooks and spreadsheets that contain a lot of data.
Creating
a Named Range
1. Select the cells for the named range.
2. In
the Name Box type a name for the range without spaces, as shown in the
figure below, and press the Enter key.
That's it! You just named a range.
Note: Hyphens and spaces should not be used in named ranges. To
indicate spacing, use an underscore.
Notice: You have the author's
permission to use the tutorials on this site for your personal
use only. If you would like to use these tutorials for
training classes or other commercial use, please contact kstille@esmartweb.com.
Distribution in print or on the Web without the author's permission
is strictly prohibited.
Featured Sites
HandofGrace.com
Quality,
affordable sterling silver beaded bracelets & mothers
bracelets. Swarovski crystals, fresh water pearls, Venetian
glass and other unique findings are featured in our bracelets.
The perfect gift for any occasion!
BakedByMom.com
Offering homemade cookie and candy boxes or gifts at reasonable prices, Baked by Mom strives to provide the best quality product in it's class. Try the White Chocolate Chip & Lime cookies, Rocky Road Candy and Caramels - they get rave reviews!
