
|
Useful Links Message
Board Guides Windows
Shortcuts Software Deals! Check
out our new bargain bin! NNY
Times Crosswords Pajama
Sam's Sock Works Business
Cards Ulead
PhotoImpact 6 Encyclopedia
Britannica 2002 w/ FREE Myst Game Norton
Personal Firewall 2002 |
Since the MS Office Tips & Tricks newsletter began, many of you have sent email asking about archives. Wel, now we have them! Yeah! To reach the old editions simply head to: http://www.worldstart.com/archives/index.htm So much information, so little time Awesome
Bible Software - The most powerful we've ever seen!
Shortcuts
Redefined Specifically I said, "A shortcut is an icon that is linked to a specific file or program. When the shortcut is double-clicked, it starts a program or opens a file and the program needed to view the file (it all depends on what it's linked to)." What I forgot to discuss was that a shortcut could also refer to a combination of keys used in a program to make a specific function or action occur. (For example, Ctrl+C copies the selected text to the clipboard.) Thanks to the reader who reminded me. Sometimes I get tunnel vision when I'm working on a newsletter. Got to work on getting the blinders off sometimes.
Quick
and Complete Worksheet Copying Most Excel users have tried at one time or another. Often when I talk to people, I find that they have varying levels of success. Some can copy only the data. Others have a little more success and can get the data and the formatting copied to a new sheet. The elusive golden ring is to get the whole worksheet copied to a new sheet. I mean EVERYTHING (including the kitchen sink - OK, maybe not quite the sink, but you get the idea). Well, here's your map to finding the golden ring. To begin an entire-worksheet copy, move your cursor over the sheet name tabs and right-click.
This will bring up a little menu. From the menu select the Move or Copy option.
The Move or Copy window will appear and offers you several options. The top drop-down box allows you to choose where the worksheet, or its copy, will end up. If you want a copy to be put into a different file, or "Book," you will need to open the other file too, before you right click. The second box lists all the sheets in the current workbook. Select the sheet that you wish to copy. Then, check the Create a copy box. (If you don't then the worksheet will be moved - not copied.) Click OK.
That's it! You'll now have an exact duplicate of the worksheet in the file or sheet you selected. OK, so you caught me! There is one difference that I could find. The worksheet copy has a slightly different name. (It is now named whatever the original was named with a (2) at the end.) Just rename the worksheet and you're on your merry way. |
Copyright & Disclaimer
ISSN: 1529-336X
Copyright 2001, WorldStart. All unauthorized
reproduction strictly prohibited.
You are welcome to reproduce this newsletter (i.e. print it, store it) for your own personal use. You are also welcome to forward it, in its entirety, to friends and family.
If you would like to reproduce
this publication, or any part of it, in any other publication, be it web based
or otherwise, you must contact us for permission. Any unauthorized re-distribution
will be considered a copyright infringement and grounds
for a lawsuit.
Finally, you agree to try
any advice contained or suggested in this newsletter at your own risk.