SPREADSHEET TIPS FROM AN EXCEL ADDICT
Helping Average Spreadsheet Users
Become Local Spreadsheet Experts
A Free Weekly Publication of TheExcelAddict.com
----------------------------------------------------------------
I Respect Your Privacy And Pledge Not To Abuse This Privilege.
This newsletter is sent ONLY to those who have Subscribed and
NEVER uses unethical methods to gain new subscribers. If you no
longer wish to receive this newsletter, you'll find a simple way
to unsubscribe at the bottom of every newsletter.
This newsletter was sent to: at
----------------------------------------------------------------
CONTENTS
1) Editor Notes
2) Excel "Quick Tips"
3) NEW "Biggest Bang For The Buck" Contest
3) T-Shirt Contest
4) "How To Excel" Mini-Tutorials
5) Reader Suggestions
6) Spreading The Word
7) "Non-Excel" Tip
8) Subscription Management
----------------------------------------------------------------
EDITOR NOTES
----------------------------------------------------------------
Hi ,
Well, I'm back from my vacation on Prince Edward Island. It was
great to get away for a while and although it involved a lot of
driving, it was worth it. My two girls loved it. Next time
you're looking for a great vacation destination, you might want
to consider Prince Edward Island. It really is a beautiful
place.
Well, it's back to work (and soccer - I've got tournaments for
the next two weekends) and I've got some tips this week that I
hope will make things easier for you.
Just a reminder that in my last newsletter I announced my new
"Biggest Bang For The Buck" contest for my loyal newsletter
readers. Check out the details below.
Think about it, wouldn't you like to have your biggest
time-consuming task in Excel reduced down to a few clicks, for
free?
To Your Success!
Francis Hayes (The Excel Addict)
----------------------------------------------------------------
EXCEL "QUICK TIPS"
----------------------------------------------------------------
Zoom Out For A Bird's-Eye View
------------------------------
When you need to select multiple cell ranges that extend out of
your current view it can sometimes be tricky selecting,
scrolling, selecting and scrolling without messing up your
selection and having to start all over again. It happens to you
too? It used to drive me nuts till I found a great little trick
to make this task as easy as pie. Just zoom out (View, Zoom) to
75%, 50% or even 25% to get a bird's-eye view of your worksheet
and begin selecting. Then, when you've got your ranges selected,
zoom back in.
Restrict Where To Find and Replace
----------------------------------
Typically when you use Excel's Find and Replace feature the
whole worksheet is searched. However, there may be times when
you want to restrict your search to a specific range of cells.
In those cases, select the range of cells before executing your
search.
----------------------------------------------------------------
MY NEW "THE BIGGEST BANG FOR THE BUCK" CONTEST
----------------------------------------------------------------
I'm excited to announce a new contest exclusively for my loyal
newsletter readers. Over the next two months I want you to
submit to me a time-consuming task that you do in Excel that you
would like to find a solution for.
I will personally review all entries and select the one that I
think could get "the biggest bang for the buck" with a solution
from The Excel Addict. The best part about this is, it won't
cost you a BUCK and you'll get the BANG absolutely FREE. One
lucky person will get a custom solution to their Excel problem
just for being a loyal reader of my newsletter. Submit your
suggestions to bigbang@TheExcelAddict.com
----------------------------------------------------------------
T-SHIRT CONTEST
----------------------------------------------------------------
Every month I am giving away a really cool t-shirt from
TheExcelAddict.com. You can sneak a peak at my website
http://www.TheExcelAddict.com
If you subscribed to this newsletter prior to this current
month, you can still get your name in for the draw each month by
helping me share this newsletter.
All you have to do each month is send an email to your friends
and associates, with a BCC to me, recommending my website and
newsletter. For each person that you refer, your name will go
into the draw. The more friends you refer, the more chances you
have of winning a t-shirt.
*** Each monthly winner will be notified by email and will have
10 days to reply with a shipping address. If I don't recieve a
reply within 10 days, another name will be drawn.
----------------------------------------------------------------
"HOW TO EXCEL" MINI-TUTORIALS
----------------------------------------------------------------
Format Only Part Of The Text Within A Cell
------------------------------------------
Everyone knows how to apply formatting to text in cells using
color, bold, italics, font size, etc... You may not be aware of
this little trick that will give you new options for formatting
your Excel worksheets. Did you know that you can apply specific
formatting to just part of the text within a cell. For example,
you could apply a different color to each word in a string of
text within a cell.
1) Select the cell
2) Highlight the text within the cell that you want to apply the
formatting to
3) Apply the formatting as you normally do. Don't press Enter
yet!
4) Select and apply formatting to other parts of the text.
5) When you're done just press Enter.
How To Report Your Numbers In Thousands
---------------------------------------
If you need to report your numbers in thousands (i.e. $23,000 as
$23), heres how to do it without having to retype everything.
1) Select the cells you want formatted
2) From the Format menu select Cells
3) In the Category list select Custom
4) In the Type box enter 0, (That's a zero and a comma)
Note: To show your numbers as millions, just add another comma
to the custom number format in step 4 (i.e. 0,,).
Remember that the displayed result is just formatted to display
as thousands. The underlying value hasn't changed. If you use
these cells in calculations, the underlying values are used. For
example $52,600 formatted as above would appear as $53. So, if
you create a formula in another cell that divides this cell by 2
the result will be $26,300 and not 26.5.
----------------------------------------------------------------
READER SUGGESTIONS
----------------------------------------------------------------
TIPS: Do you have an Excel tip you'd like to share with
everyone, please send it to tips@TheExcelAddict.com
TESTIMONIALS: Please drop me a line at kudos@TheExcelAddict.com
and let me know how my Tips, Tricks, Shortcuts, and Techniques
have helped you.
COOL STUFF: Do YOU know of some "out-of-the-ordinary" really
cool thing that YOU can do in Excel? Share it with me and I may
publish it in a new section coming to my website called "Cool
Stuff You Can Do With Excel". Send your suggestions to
coolstuff@TheExcelAddict.com
OTHER COMMENTS: If you have any other comments or suggestions,
please don't hesitate to let me know at
francis@TheExcelAddict.com
----------------------------------------------------------------
SPREADING THE WORD
----------------------------------------------------------------
Currently this newsletter is reaching Excel Addicts in: Canada,
USA, Britain, Germany, Norway, Brazil, Saudi Arabia, China,
Australia, South Africa, Jordan, Singapore, the Philippines and
South Korea.
There are tens of millions of other Microsoft Excel users all
over the world. The vast majority of them have a very limited
knowledge of Excel's capabilities. My goal is to share this
information with everyone I possibly can and help them to
benefit from Excel's lesser know capabilities.
, please help me spread the word about my
newsletter. If you know other Excel users, please tell them
about "Spreadsheet Tips From An Excel Addict". You can forward
this email to them or, if you'd like to qualify for my T-Shirt
Contest, go to my website TheExcelAddict.com and use the Refer A
Friend link to let them know. I'm sure they'll appreciate it.
Please refer only people you know personally, who use Microsoft
Excel and could benefit from this newsletter.
PLEASE NOTE: Before you forward this newsletter to anyone else,
first delete the Unsubscribe Link at the bottom of this
newsletter. You wouldn't want someone to 'accidentally' remove
your name from my mailing list, would you?
----------------------------------------------------------------
BONUS "NON-EXCEL" TIP
----------------------------------------------------------------
Quickly Copy A File To Your Floppy
----------------------------------
A little-known shortcut for quickly copying a file to a diskette
is to right-click on the file and select Send To, 3 1/2 Floppy
(A).
----------------------------------------------------------------
SUBSCRIPTION MANAGEMENT
----------------------------------------------------------------
If this newsletter was forwarded to you from a friend and you
would like to get your own copy, just send a blank email to
TheExcelAddictNewsletter@infogeneratorpro.com
----------------------------------------------------------------
"Spreadsheets Tips From An Excel Addict" is a weekly publication
of TheExcelAddict.com. Copyright 2003, FJH Marketing. All Rights
Reserved. 8 Lexington Place, Conception Bay South, Newfoundland,
Canada, A1X 6A2 Phone: 709-834-4630
---------------------------------------------------------------- |