************************************************************
SPREADSHEET TIPS FROM AN EXCEL ADDICT
Helping Average Spreadsheet Users
Become Local Spreadsheet Experts
Thu Aug 14, 2003
A Free Weekly Publication of TheExcelAddict.com
http://www.theexceladdict.com
************************************************************
I Respect Your Privacy And Pledge Not To Abuse This Privilege.
This newsletter is sent ONLY to those who have Subscribed, is
completely 100% opt-in and NEVER uses spam or bulk email 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:
Francis at
************************************************************
CONTENTS
************************************************************
1) Editor Notes
2) Excel "Quick Tips"
3) T-Shirt Contest
4) "How To Excel" Mini-Tutorials:
5) "Non-Excel" Tips
6) Reader Suggestions
7) Spreading The Word
8) Subscription Management
************************************************************
EDITOR NOTES
************************************************************
Hi Francis,
Welcome to another edition of "Spreadsheet Tips From An Excel
Addict." I hope you enjoyed last weeks newsletter and found the
tips helpful.
Remember to take a few minutes each week to actually practice
using these tips and shortcuts, even for those ones that, at
first, may not seem to apply to your situation. The simple act
of doing these tips will often open your mind to other
possibilities that you hadn't thought of previously.
That's what it's all about, "expanding your knowledge of
Microsoft Excel and how to best use it to your benefit." I hope
this weeks tips will save you time, money, or frustration.
Preferrably all three.
Francis, I'm asking you for a small favor. Could you please help
me share this newsletter with other Excel users by Forwarding it
by email to your Excel friends and associates (see the SPREADING
THE WORD section below regarding Spamming) or posting it on a
bulletin board at your place of work. Maybe you could even
recommend to your Accounting Manager to subscribe all Excel
users to the newsletter. After all, the more people that use
these tips, the more time will be saved, and time IS money, and
best of all, it's free. You can't beat that!
Thanks in advance for your help and and I hope you'll enjoy this
weeks new tips.
To Your Success!
Francis Hayes (a.k.a. The Excel Addict)
************************************************************
QUICK TIPS
************************************************************
----------
Quick Jump
----------
To quickly jump to the end of a range of cells, you can
double-click the edge of a cell in the direction you want to
move. Double-click on the edge of any cell, and you will jump to
the last contiguous cell in that direction. You can also hold
down the SHIFT button and double-click the edge of a cell to
select the entire range from the active cell to the last cell in
the desired direction.
--------------------------
Uncovering Your Sheet Tabs
--------------------------
When you have many sheet tabs in your workbooks, some of the
tabs may not be visible, so you have to click on the scroll
arrows to the left of the sheet tabs to uncover your hidden
sheet tabs. If there are only a few of your sheet tabs hidden, a
better option may be to adjust the size of your horizontal
scroll bar to give more room to your sheet tabs. You can resize
the scroll bar by moving the cursor to the small split bar just
to the left of the horizontal scroll bar. You will see the
cursor change to a left and right arrow pointer. Hold down your
left mouse button, drag to the right to resize the scroll bar
and release. Don't make your horizontal scroll bar too small or
you will have another problem.
************************************************************
T-SHIRT CONTEST
************************************************************
Every month I will be 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 refer your friends and
associates to my website and newsletter through the Refer A
Friend link on my website. 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. (See the SPREADING THE
WORD section below for important details on Spamming)
************************************************************
"HOW TO EXCEL" MINI-TUTORIALS
************************************************************
----------------------------------------------
How To Indent Text Without Adding Extra Spaces
----------------------------------------------
Many times you will find that when you have a column of text
immediately to the right of a column of numbers they both look
'sqeezed' together.
Many people insert spaces at the beginning of each of their text
entries to provide some 'white space'. There are various reasons
why this is not the best option, including the fact that it is
very time consuming.
There is a much easier way easier way to achieve the same result
without the various side-affects.
Here's how:
(1) Select the cells that contain the data you want indented;
(2) From the Format menu select Cells... ;
(3) Click on the Alignment tab and select Left (Indent) from the
Horizontal dropdown list;
(4) On the Indent spinner box set the number of spaces you want
to insert between the start of your text and the left edge of
the the column;
(5) Click OK and you're done.
If you find that you use this procedure often you may want to
customize your toolbar to include the Decrease Indent and
Increase Indent buttons. That will allow you to accomplish the
same result in fewer clicks.
-----------------------------------------------
How To Display Text In A Cell On Multiple Lines
-----------------------------------------------
Did you know you can create line breaks within cells to give you
multiple-line headings in the same cell. Sometimes the text for
your column heading is wider than the data in the column. For
example, a column heading called Monthly Expenses would require
a much wider column than the data below it, resulting in a lot
of wasted space. Rather than having a column that is too wide
just to accommodate your heading, you can split your heading
into multiple lines within a single cell.
Here's one option:
(1) Select the cell where you want the label or heading to
appear;
(2) Type the first line of information;
(3) Press ALT+ENTER;
(4) Type the second line;
(5) Repeat step 3 if you have additional lines to enter.
Using the above method, Excel will automatically wrap the text
and adjust the row height for each cell in which you use
ALT+ENTER.
Another way to wrap text in a cell, is to format the cells so
that Excel will automatically wrap them based on the column
width.
Here's how:
(1) Select the cells that you would like to apply a Wrapped Text
format to;
(2) From the Format menu select Cells and then click the
Alignment tab;
(3) Put a check mark in the Wrap Text option and click OK.
Now whenever you enter text in any of these cells that is too
wide to fit in the column, Excel will automatically wrap the
text to a new line based on the column width and adjust the row
height.
The advantage of the first method is that you can force the line
break wherever you want. The advantage of the second method is
that you don't have to use ALT+ENTER. You can have the best of
both worlds by using the second method and then, in cells where
the text doesn't break where you want, you can use ALT+ENTER.
Go ahead and try it.
If you find this tip helpful, please forward a copy of this
newsletter to friends and associates you think would also
benefit from these tips.
************************************************************
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 satisfied readers in:
Canada, USA
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.
Francis, please help me spread the word about this newsletter.
If you know other Excel users, please let them know 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 http://www.theexceladdict.com and use
the Refer A Friend link to let them know. I'm sure they'll
appreciate it.
NO SPAMMING! Please refer only people you know personally and
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
************************************************************
--------------------------------
Copying Graphics From A Web Page
--------------------------------
Most Internet surfers don't realize how simple it is to copy a
picture or graphic from a web page and insert it into almost any
document you like.
It's as simple as right-clicking on the web graphic and
selecting Copy or Copy Picture (depending on the browser you are
using) and then switching to your document and pasting it in
there.
This works great for doing research projects where you gather
the information from the Internet and then put it into you own
document which you can edit. Adding pictures and graphics will
enhance your projects and this is a quick and easy way to do it.
************************************************************
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.
------------------------------------------------------------
|