[mso] Re: Performing Calculations Using IF or VLOOKUP

Yes..I used a named range...just highlight all the data you want included in
the name, then click in the Name Box on the left end of your toolbar (it's
the box that shows the name of the cell you are currently in)...once you
click in that box, you will see the cell reference that was there shoots
over to the left and is highlighted...just type in your name you want to
use, then hit Enter...you MUST hit Enter or it won't take.

Now, your range is named.

I'm planning to write a naming ranges tutorial for the next issue of
TechTrax for Dian...not this one coming up, I've already done that one, but
the next one...there are MANY features of Excel that are MUCH easier to use
if you use named ranges and many people don't even know they exist.

For example, they work like bookmarks...once you've named a range, it will
now appear in the dropdown in the Name box...if you select it from there, it
will move you immediately to the named range and highlight it for you 


Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Michele Wong
Sent: Tuesday, November 25, 2003 1:10 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Performing Calculations Using IF or VLOOKUP 

I think I understand most of it, but can you tell me how you named the
table to "commissions"?

Thanks,

Michele B. Wong


*************************************************************
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).
http://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: