[March 31, 2008]
It's staying light out longer now which always makes me feel like I'm getting extra time to do things in my oh so short days. I'm not too crazy about getting up in the morning while it is still dark but I love having that extra daylight at the end of the day. In addition to hearing the peepers singing at night I am now awakened by the sound of birds chirping on the deck. I absolutely love this time of year. Wherever you are on this old planet, I hope that you are enjoying whatever season is upon you.
Lets give a great big welcome to Mickey, Dave, Charles, Andrea, Paula, and Elizabeth, the latest additions to our family! Welcome and we all hope you enjoy the newsletter!
Table of Contents
Spell Check All your Worksheets in MS Excel - Make sure there are NO spelling errors.
Legal Line Spacing in MS Word - Anything to save time!
Close It All in MS Word - More savings of time and keystrokes.
Spellcheck All your Worksheets in MS Excel Workbook
I bet that a lot of you were not aware that when you run the Spell Check feature in MS Excel, it only checks the instant worksheet and not the others in your multiple worksheet workbook. No? You didn't know that? Well then I am glad that I have now brought it to your attention!
So now that you are aware of this I will proceed to tell you how to make Excel check all of the worksheets in your workbook.
Follow the steps below to learn how:
- Select all the worksheets before you run the Spell check!
That was quick and easy wasn't it? What? You don't know how to do that? Ok, I will show you!
- Right-click on a sheet tab and choose Select All Sheets from the resulting shortcut menu that appears.
You can now use the Spell Check feature in Excel and know that all of your worksheets are being checked.
Legal Line Spacing in MS Word
A lot of legal secretaries have written to me asking for ways to quickly change the line spacing in a document as they are frequently moving from single line spacing for block quotes and double line spacing for text and then back to single line spacing for signature blocks in pleadings.
It really isn't all that difficult. If you find that you are frequently changing the line spacing in MS Word to double or you are making the switch more often than not, it's time to take measures so that this happens seamlessly and without lots of time and keystrokes.
After speaking with more than a few of these secretaries I found that most of them were using the Normal style in their documents and so I will assume for this tip that everyone is, although hopefully not!
I could tell you how to modify your Normal.dot style, which is the style on which you base every new document in MS Word, but I don't see the point to that because then every document you create would have double line spacing. Wouldn't that be a fine howdy do?
Instead, I will give you a quick key combination to use to change your line spacing on the fly in your documents.
When you are setting up your document using the Normal.dot style, everything will be in single line spacing.
- Once you have typed the heading of your pleading, you now want to start using double line spacing so place your cursor where you want that spacing to start and depress and hold your CTRL key and click the number 2 on your keyboard.
- That's it! When you want to go back to single spacing, depress and hold your CTRL key and click on the number 1 on your keyboard.
Quick and easy, just the way I like it!
Closing it All in MS Word
If you are anything like me, you have lots and lots of documents open at the same time when you are working in MS Word. Hopefully, I have taught you well and you save your documents at the beginning and end of your work
But wait, don't you hate closing each of those documents? It can become tedious, especially when you have to get them all closed to leave at the end of the day or when you have to close many sensitive documents before you go to lunch.
That's where the keyboard shortcuts come into play. Follow the steps below to learn how:
- In MS Word when you are ready to close up shop, depress your Shift key and keep it depressed and then click on File.
- You will notice a command that says Save All. That command is not visible if you do not employ the Shift key.
- Just above that command, you will notice another one that says Close All.
The commands work pretty much as you would expect - no big surprises. And they leave MS Word open and running for you.
Less time - less keystrokes!
Included in the Premium Newsletter:
- Clocks in your Calendar in MS Outlook
- Set Up Meetings Anywhere
- Quicker Accents
- Desktop Alerts in MS Outlook
Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.