[November 15, 2009]
It is dreary and raining as I sit here creating the newsletter. One would never know that just a few short days ago I was in North Carolina and it was sunny and warm like summer. I do love the hospitality of the south; everyone is so genteel and polite. I guess that's why I like to visit there.
But back to reality! It is chilly and rainy and I am scrambling to get caught up with everything that wasn't done while I was away and now it's two and a half weeks from Thanksgiving! Wow! Where did that time go for pity sakes! I know the holidays are getting closer and closer because every day my mailbox is inundated with catalogs and I do mean inundated! So much paper being wasted!
I made the annual phone call today to find a family to adopt for Christmas. I am sure there are plenty in need this year moreso than years gone by. I have a lot of fun buying toys for children who otherwise would not have a Christmas. It just makes you feel good to do something for someone else you know? My family and I really get into it. We purchase all the fixings for a holiday meal and we finish it off with homemade cookies, pies and cakes. We always ask for a wish list for our family and the adult is always reluctant to give us one but everyone deserves a visit from Santa right? You really see kindness this time of year; everyone wants to help us out with our family. Let's hope the spirit will continue for the rest of the year!
We also recently celebrated Veterans Day here to thank all of our service men and women and remember those who have gone before. Thank you to all of you who protect us and keep our country free!
Wherever you hale from, I hope that you are all gearing up for this festive time of year. Please try remember to stay calm and try to keep a few moments to savor and enjoy.
Please join me in welcoming K. Case, Timothy, Steven, Chris, Richard, Giscard, James K., Gord, Anthony, Michael, Dennis, Russell Mc., Russel R., William, Scott, Van, Victor, and Rita, 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
Using Keyboard Shortcuts in MS Excel - Easy to do!
Add a Watermark in MS Word 2003 - Have it your way!
Borders and Boxes in MS Word 2003 - Easy reminders!
 |
|
Using Keyboard Shortcuts in MS Excel
To open the Insert Function dialog box:
- Select an empty cell and click Shift + F3.
To open a Function Arguments dialog box:
- Select a cell containing a formula and click Shift + F3.
To insert a new Formula into a cell using the Function Arguments dialog box:
- Select an empty cell, and type the = sign.
- Type the formula name and press Ctrl + A.
To insert a formula by typing it while being guided by the formula syntax tooltip:
- Select an empty cell and type the = sign, followed by the formula name and a ( .
- Click Ctrl + Shift + A.
For versions 97, 2000, 2003
Add a Watermark in MS Word 2003
To add a watermark to a document follow the steps below:
Click on Format | Background | Printed Watermark.
The watermark is inserted as part of your document's header. By working directly with the header, you can manually change the watermark as in moving, resizing, or even deleting it if you like.
Borders and Boxes in MS Word 2003
You can draw borders around characters, paragraphs, table cells, or pages in MS Word.
Follow the steps below to learn how:
- Select the character, paragraph, cells or table you would like to format.
- Click on Format | Borders and Shading.
- On the Borders tab, make sure the Apply To box shows the correct setting (e.g. paragraph, text, cell, or table).
- From the common settings along the left, you can choose or draw your own border in the Preview pane on the right.
- Select the line style, color and width in the center pane.
- To set the distance between the text and the border, click on Options and fill in the amounts.
- Click OK .
The border now appears!
Included in the Premium Newsletter:
- Overriding the Default Message Format in MS Outlook
- Using Large Toolbar Buttons in MS Word
- Inserting Headers & Footers in Multiple Sheets in MS Excel
- Reset your Toolbars in MS Word
- Open Specific MS Excel Workbooks at Startup
- Transfer an Older Personal.xls to MS Excel 2007
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.