[mso] A little Range Naming tutorial for Excel Users
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 23 Sep 2003 07:46:57 -0400
<<I didn't even realise you could name cells - that should make formatting
& formulae much easier!>>
Hey Anne...using range names in Excel is a real time saver....not only in
formulas...but it's also Excel's version of "bookmarks"
Here's a little sample of that. Let's say you have a huge spreadsheet and
on the fifth sheet in cell FF1207 you have a total that you often have to
check...go to the fifth sheet and click on cell FF1207...then click in the
Name box on your toolbar and you will see FF1207 highlights in that box and
shoots over to the left...type YrTotal in there (or whatever name you
choose) and hit Enter (you must hit Enter for the name to take...if you just
click outside that box, the name will not hold)....now go ANYWHERE in your
workbook....let's say you are in cell MM5567 on sheet ten and you want to
check that total...just go the the Name box, click the dropdown and click on
YrTotal and BINGO...you are there. How's THAT for handy?
You can name cells, ranges of cells, and even constants...
Let's say you have some weird number like 12.78999642 and you have to
repeatedly multiply various numbers in your workbook by this number...well,
you can risk typing it in all the time and hope you don't make an error or
you can just name that constant. To name a constant, go to the Insert menu
and choose Name, then Define...in the top box, give it a name...for this
example, I'll use "increase" (without the quotes)...now in the box at the
bottom that says "Refers to" type 12.78999642. Click Add, then OK...now go
into any cell and type =increase*10 or =D5+increase or any formula you want
and you will see that the word increase will always refer to that weird
number. (Named constants don't show in your Name dropdown list becuz they
don't actually refer to a location in the workbook)
And...a couple other cool things (since I see you love keyboard
shortcuts)....go into a cell and type =D4+ and hit the F3 key and there's
your paste names box...just double click the name you want and it's added to
your formula
And....let's say you have a BUNCH of names in a workbook and you want to
know what they all refer to....go to a blank sheet and hit F3 again and in
that box, click on the button that says Paste List...and now you have a full
list of all the names in your workbook and it shows what they refer to....go
to cell A1 on that sheet and give that cell a name...now you have a bookmark
in your Name Box dropdown that can jump you to that page anytime you want to
see all the names in your workbook.
And, now, like Dian...I have the beginnings of a good article for TechTrax
myself LOL
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
- » [mso] A little Range Naming tutorial for Excel Users
