[February 15, 2010]
On February 5th we had a blizzard in my area that dumped between 24 and 30 inches of snow depending upon where you lived. And then again, on the 8th we got hit again witn another blizzardI got plenty of exercise digging out cars and shoveling the driveway. None of it bothered me while I was doing it but once I sat down I was done! I said a silent prayer in gratitude that I could do what needed to be done. A lot of folks were without electricity and their neighborhoods had not been plowed. We have had a record amount of snowfall this year - approximately 64 inches! I am soooo ready for Springtime! Keep your fingers crossed - snow is predicted for the coming week!
I hope you all have enjoyed a lovely Valentine's day with your significant other. Some folks don't believe in exchanging gifts, but instead insist they show their love all year round. Me, I prefer a gift. It doesn't have to be a huge spectacle, just a small token of affection - something that is meaningful. But whatever suits you, I hope your Valentine's Day met your expectations and that you all feel appreciated and loved by the folks who are significant to you and you make sure that they feel the same.
Please join me in welcoming Ernest, Judith, Leonard, Pearl, Linda, Charles, Herbert, Norman, and Ted as the latest premium subscribers to Carol's Word Bytes Newsletter. Welcome to the family! If you know someone who struggles with an application in Microsoft Office, like Word or Excel, do them a favor and tell them about our newsletter. They will always thank you for it!
Let's get to the tips now!
Table of Contents
Quick Access to the Horizontal Ruler in MS Word - Space saver!
Enter a Slashed Zero in your MS Word Document - It can be done!
Align Objects with Cell Borders in MS Excel - Have great looking Worksheets!
 |
|
Quick Access to the Horizontal Ruller in MS Word
MS Word displays the horizontal ruler depending upon which view you use. It will be displayed in the Normal, Print, and Web view. If it is not visible, simply click on View | Ruler. The Ruler is not available in Outline of Master Document views.
Some folks do not like to have the horizontal ruler visible as it takes up valuable real estate space on their Word screen. It is, however, possible to have the best of both worlds. You can have your horizontal ruler available to you and still have extra real estate space available on your screen.
Even if you turn off the Ruler it is still there represented by a thin gray line. All you need is the proper settings!
- Click on Tools | Options.
- Click on the General Tab.
- In version 2007, click the Office button and Word Options. Then select Advanced on the left-hand side.
- In the General Options area, check the Provide Feedback With Animation option.
- Click OK.
With the Ruler unchecked on the View menu and the above setting, you can position your cursor over the gray line below the toolbar and the animation setting will kick in and the Ruler will roll down. When you move the cursor away from the Ruler it rolls back up under the Toolbar.
Enter a Slashed Zero in your MS Word Document
There are some occasions when one may want to add the occasional slashed zero in a document. There are a couple of methods to accomplish this in MS Word, such as passwords to differentiate between a number zero and a capital letter O.
Follow the steps below to learn how:
- Position your insertion point where you would like to insert your slashed zero.
- Click Ctrl + F9. MS Word will insert field braces.
- Between the braces, key in eq \ o (0,/).
- Click Shift + F9 and MS Word will display your slashed zero.
That's all there is to it!
Align Objects with Cell Borders in MS Excel
If you use text boxes frequently and other AutoShapes in your workbooks, you might want to align those objects with the edge of your cells. Before I learned this handy little trick it drove me to distraction when trying to align!
Follow the steps below to learn how:
- Select the object you would like to align and depress and hold down the ALT key while moving it.
You can also resize objects to fit a cell or range of cells by dragging the sizing handles using the same trick!
Included in the Premium Newsletter:
- Add A Dynamic Total in your MS Word Document
- Automatically Update Fields and Links in your MS Word Document
- Which Column Number in MS Excel?
- Display User Input Message in MS Excel Cell
- Calculate Form Fields in MS Word
- Combining Documents in MS Word
Shouldn't you be a premium subscriber?? With a premium subscription, you get more than double the content and NO advertising! Plus, most instructions come with clear screenshots! With your premium subscription you also receive access to an archive of five years of newsletters and deep discounts on all books and tutorials I publish!! So what are you waiting for? Sign up today!
Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.