*******************************************************
DUMMIES eTIPS: Microsoft Excel
http://etips.dummies.com
*******************************************************
TODAY'S eTIP(TM): Referencing Cells Far and Wide
If your formula needs to refer to a cell in a different worksheet
in the same workbook, use the following format for your formula.
SheetName!CellAddress
Precede the cell address with the worksheet name, following it
with an exclamation point.
Remember: If the worksheet name in the reference includes one or
more spaces, you must enclose it in single quotation marks. The
following is a formula that refers to a cell on a sheet by the
name of All Depts:
=A1*'All Depts'!A1
If you like your answers quick and your information up-to-date,
check out Excel 2002 For Dummies Quick Reference
[
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=FeaturedTitles=www.dummies.com/WileyCDA/DummiesTitle/productCd-0764508296.html
],
by Colin Banfield and John Walkenbach.
Related Articles
Ordering Up Organizational Charts in Excel 2002
[
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=RelatedArticles&link=www.dummies.com/WileyCDA/DummiesArticle/id-302.html
]
Printing Your Worksheet the Way You Want in Excel 2000
[
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=RelatedArticles&link=www.dummies.com/WileyCDA/DummiesArticle/id-35.html
]
Taming the Excel 2002 Task Panes
[
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=RelatedArticles&link=www.dummies.com/WileyCDA/DummiesArticle/id-304.html
]
*******************************************************
*******************************************************
WIN ROXIO'S EASY MEDIA CREATOR 7!
Dummies.com has teamed up with Roxio to give away
Roxio's Easy Media Creator 7 Digital Media Suite,
a package of award-winning media applications that
will help you organize, edit, and preserve all your
digital media. One lucky winner will receive PhotoSuite 7,
VideoWave 7, Easy CD & DVD Creator, and Napster 2.0.
These applications are seamlessly integrated to enable
you to creat amazing multimedia.
Drop in soon to enter.
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=SweepsRoxio&link=www.dummies.com/WileyCDA/Section/id-102732.html
*******************************************************
DEMYSTIFY OS X, DOS, AND XP
Find new ways to put your computer to work with help
from our Operating Systems subcategory.
Drop by for a visit anytime.
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=OperatingSystems&link=cda.dummies.com/WileyCDA/Section.rdr?id=100014
*******************************************************
YOU'RE SO CRAFTY
To pass a snowy winter day, prepare for a
loved one's birthday, or even get a jump
start on a Valentine's Day, you'll never
run out of craft ideas on our Hobbies Page.
Drop in soon.
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=Crafts&link=cda.dummies.com/WileyCDA/Section.rdr?id=100034
*******************************************************
A WORD FROM US
*******************************************************
Hello [EMAIL PROTECTED] This commercial e-mail is coming
your way because you subscribed to the service at http://etips.dummies.com/.
If you'd like to add more topics, choose a different format,
have your eTips sent to a different e-mail address, subtract
topics, or unsubscribe, visit http://etips.dummies.com/change.asp.
*******************************************************
A WORD FROM OUR LAWYERS
*******************************************************
This absolutely FREE service is brought to you by Dummies.com (http://www.dummies.com).
Copyright 2004, Wiley. All Rights Reserved.
Wiley Publishing, Inc. Attn: Dummies.com 10475 Crosspoint Blvd. Indianapolis, IN 46256
Customer Care: 1-877-762-2974
Contact Us
http://www.dummies.com/WileyCDA/Section/id-100100.html
Privacy Policy
http://www.dummies.com/WileyCDA/Section/id-100065.html
A Word From Our Lawyers
http://etips.dummies.com/disclaimer.html
