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) 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 ,
Welcome to another edition of "Spreadsheet Tips From An Excel
Addict."
I'm sure this weeks tips will help save you valuable time and
make working with Excel even easier.
Just stop for a second! Can you think of other Excel users who
would love to be recieving FREE weekly spreadsheet tips just
like you? I'm sure you know many. Why not forward this
newsletter to them so they can sign up for their own
subscription? I would appreciate it - and I'll bet they would
to.
Also, if you have any favorite tips that you'd like to share
with everyone else just send them along to
tips@TheExcelAddict.com If I use your tip, I'll give you credit
for it in the newsletter.
Have an awesome week and I'll see you back here next week.
To Your Success!
Francis Hayes (The Excel Addict)
----------------------------------------------------------------
Are you new in management, or trying to break into the
management ranks?
----------------------------------------------------------------
If so, you should check out my good friend Coach Dave at
Coaching For Tomorrow (http://www.CoachingForTomorrow.com).
Coach Dave specializes in helping you make the transition to
manager, or to upper management. Coach Dave publishes a no-cost
monthly newsletter as well as semi-monthly management tips to
help you get ahead!!! Send an blank email with "Ref-TEANL" in
the Subject line to subscribe@CoachingForTomorrow.com
Coach Dave recently released "So, You Want To Be A Manager", his
second fee-based newsletter. This newsletter includes 12 monthly
issues on important management topics that you need to be in
tune with to be a success. Written in a clear, no-nonsense
style, "So, You Want To Be A Manager" will get the gears turning
in your head and help you break the code on management. Order by
July 15th and pay only $25 for all 12 issues (that's $5 off the
regular subscription price)!!! Check it out at
http://www.CoachingForTomorrow.com
----------------------------------------------------------------
EXCEL "QUICK TIPS"
----------------------------------------------------------------
Quickly Switching Between Sheets In Excel
-----------------------------------------
Here are a couple of neat little shortcuts to help you move
around the sheets of your workbook.
To move one worksheet to the right press CTRL+PAGE DOWN.
To move one worksheet to the left press CTRL+PAGE UP.
Now you can zip through those worksheets with lightening speed.
Setting The Print Area With One Click
-------------------------------------
Setting the print area using File | Print Area | Set Print Area
is a task we all do frequently. Do you have the Set Print Area
button on your toolbar? Depending on which version of Excel you
are using, the Set Print Area tool may not be included on your
toolbar. If it isn't, here’s how to get it:
1) From the View menu select Toolbars, and then click Customize.
2) Click on the Commands tab and in the Categories box select
File.
3) In the Commands section scroll down till you see the Set
Print Area button.
4) Hold down your left mouse button and drag it on to an
existing toolbar.
----------------------------------------------------------------
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 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.
----------------------------------------------------------------
"HOW TO EXCEL" MINI-TUTORIALS
----------------------------------------------------------------
How To Combine Text in Cells
----------------------------
Here’s another little-known feature available in Excel that I
bet you’ll find various uses for. It is the ability to combine
text from multiple cells into another cell.
I use it frequently for joining text when I receive a file that
has first and last names in separate columns. This feature
allows me to easily combine the last name from one column with
the first name of the other column and show the result as a full
name in another column.
Let me show you how easy it is.
Before I get started, when talking about text I'll often use the
terms ‘string of text’ or ‘text string’ to refer to text.
The best way for me to show you how this works is to give you a
simple example to do yourself.
In cell A1 enter "First"
In cell A2 enter "Mickey"
In cell A3 enter "Ozzy"
In cell A4 enter "Bart"
In cell B1 enter "Last"
In cell B2 enter "Mouse"
In cell B3 enter "Osbourne"
In cell B4 enter "Simpson"
Lets pretend that this is a spreadsheet with a list of 300 names
and you need the full name in one cell. How would you go about
doing this? It could take hours to retype hundreds of names.
Here’s the trick.
In cell C1 enter "Full Name" as your column heading.
In cell C2 enter either of the following formulas:
=A2 & " " & B2 (will give you "Mickey Mouse")
=B2 & ", " & A2 (will result in "Mouse, Mickey")
Now just copy the formula down for the remaining cells. At this
point you'll want to convert the formulas in these cells into
values. To accomplish this, just highlight all of the formulas
in column C, click Edit, Copy, and then click Edit, Paste
Special, Values, OK. Now, if you want, you can delete the
original two columns of data.
NOTES: To insert a space between the first and last names we
have added a space between two quotation marks. The ampersand
(&) joins the text string from each cell into one string of
text.
Keep Those Headings Visible
---------------------------
When you are working with a worksheet with many rows and columns
and you want to keep your row of column headings always visible
on the screen as you scroll down through the rows, here's what
to do.
Click the row directly below your row of headings and select
Window | Freeze Panes.
If you want to keep the left-hand column of Row Labels visible
instead, select the column immediately to the right of your
labels and select Windows | Freeze Panes.
Now, let's assume you have column headings in Row 1 and row
headings in Column 1 and you want to keep both the row and
column labels visible as you scroll down and to the right. You
will need to select the cell immediately below and to the right
of your labels (in this example cell B2) and select Windows |
Freeze Panes.
Now, scroll to the right and scroll down and see what happens.
----------------------------------------------------------------
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
----------------------------------------------------------------
Website Not Found May Have Just Moved
-------------------------------------
How many times have you clicked on a link for something on the
Internet only to end up with a "The page cannot be found" error
message. Most people give up right there. However, many times
the page that appears to be non-existant may have only been
renamed or moved.
If you wind up at an error page like this, don't give up so
easily. Try going to its home page and then looking for links to
the page you are looking for. To get to the home page, delete
the end of the address (everything to the right of .com, .net,
etc...) and then press Enter.
Now you can look for a link to that other page.
----------------------------------------------------------------
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
----------------------------------------------------------------
|