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 ,
Have you been reading and practicing all these great tips? Good!
I promised you that I would help boost your productivity in
Excel, and by doing your part and actually applying these tips,
I'm sure you are beginning to see some results already. Well,
I've got some more great tips for you this week that I hope
you'll like. Remember to share these tips with all your Excel
associates.
Have a great week and I'll see you 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"
----------------------------------------------------------------
The Fastest Way To Select A Block Of Cells
------------------------------------------
The most common use for Excel is creating tables - usually so
many columns wide by so many rows long.
You will also find that many times you need to select that whole
table, either for formatting purposes, for printing a selection
(see How To Print Just A Small Section Of Your Worksheet in my
June 2nd newsletter), or various other reasons. The usual way to
select the range of cells is to click in the top-left corner and
drag down to the bottom-right corner.
Depending on how big the table is, this may or may not be a
simple task. But, if you'd like a lightning-fast way to select
the whole table, just click anywhere in the table and press
CTRL+SHIFT+* (asterisk).
The Extend Selection Mystery
----------------------------
Every Excel user must have come across this situation. All of a
sudden, when you click a cell or move using the arrow keys, a
whole range of cells is selected. It won’t allow you to select
one cell.
I remember the first time this happened to me many years ago,
completely frustrated I couldn’t figure out what the problem was
so I restarted Excel. It happened to me several more times
before I discovered that the problem stemmed from accidentally
pressing the F8 (Extend Selection) key. Just pressing the F8 key
again solved the problem.
Remember this one, because sooner later it will happen to you.
----------------------------------------------------------------
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
----------------------------------------------------------------
Easily Copy Your Print Settings From One Sheet To Another
---------------------------------------------------------
Each sheet in your workbook has its own print settings (i.e.
orientation, headers and footers, margins, etc...). You select
these options in the Page Setup dialog box by selecting File,
Page Setup.
When you add a new sheet to your workbook, it contains the
default page setup settings. Many times you will have multiple
sheets that are identical and therefore you'll want them to have
the same print settings.
Here's a neat trick that will allow you to quickly and easily
transfer print settings from one worksheet to other worksheets
in your workbook.
First, select the sheet tab for the sheet that has the settings
you want to duplicate. Next, while holding down the Ctrl key,
select the sheet tabs that you want the print settings
transferred to. Then from the File menu select Page Setup and
click OK.
No, I never missed a step! That's all there is to it! The Page
Setup settings of your source sheet have been transferred to all
of the other selected sheets.
Create A Linked Picture Of A Range Of Cells
-------------------------------------------
Who says you can't be in two places at the same time?
Here is a neat trick that I bet you'll find many uses for
Believe it or not, in Excel you can 'take a picture' of a range
of cells and paste that picture anywhere in your workbook.
The great thing about this is that the picture is linked to that
range of cells and whenever the contents of those cells change,
the picture is also updated. This is useful when you are working
in one part of your workbook and you want to see how changes you
make affect another part of your spreadsheet. You'll probably
think of a hundred other uses for it.
To create a linked picture:
1) Select the cells whose picture you want to take;
2) Click Edit | Copy;
3) Go to where you want to place the picture;
4) While holding down the SHIFT key click on the Edit menu and
select Paste Picture Link. The Paste Picture Link menu item is
available only when you hold down the SHIFT key while clicking
on the Edit menu.
The result is a linked picture that is updated whenever the
source cells are changed or formatted. If the picture has an
invisible background so you may find the need to add some
background color to it (Format | Picture | Colors and Lines, and
select a Fill color) to make it easier to read.
NOTE: If you don’t want you’re picture linked, you can click
Paste Picture instead to give a snapshot of the copied cells.
----------------------------------------------------------------
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
----------------------------------------------------------------
Cover Your Tracks in Internet Explorer
--------------------------------------
Internet Explorer stores a list of the websites you've visited
in its History folder. This is a great convenience when you want
to revisit that website you looked at last week. But it also
means that anyone else with access to your computer can also see
which websites you've visited.
Here's what you can do to get rid of any unwanted website
history. From the Tools menu, go to Internet Options. Under the
General tab, find the History section, and click the Clear
History button.
If there are only a couple of sites that you want to remove,
there's no need to wipe out everything. Just click the History
button (looks like a sundial) on the Internet Explorer toolbar.
You'll see a list of websites displayed on the left of the
screen. Find the site you want to remove, right-click on its
folder and select Delete.
----------------------------------------------------------------
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
---------------------------------------------------------------- |