[January 1, 2009]
Wow! It doesn't seem possible that another year has passed! I'm thinking back over 2008 and all the mistakes I made and all that I learned from those mistakes, not to mention all the new books that I have read, all the friends I've made along the way, and sadly some I may have lost. I think about all my humbling moments as well that remind me on a daily basis that I am but a speck in the universe. I like to think that I have grown over this past year and that I have left my footprints somewhere along the way, that I have helped a a few folks and not upset too many.
We all move forward and hopefully help each other along the way, so let's all move forward together this year and I will do my best to give you the very best newsletter that I can and I will rely on each and every one of you to let me know if I am missing the mark and to let me know what I can do better!
I would like to take this opportunity to thank all of your for your continued confidence, interest and support for without you there would be no newsletter. Happy New Year to all!
Please help me to welcome Keep, Burley, Preston, Michael, and Lane as our newest premium subscribers. Welcome to the family!
Don't forget that one of the best gifts you can give is that of education. You can give a premium subsciption of Word Bytes Newsletter as a gift to someone you love!
Let's get to the tips now!
Table of Contents
Quick Keys in MS Access - Time Saver!
Change Directions in MS Excel - Have it your way!
Change Numbers in your MS Word Captions - You will love this!
 |
|
Quick Keys in MS Access
| To Perform this Action: | Press |
|---|---|
| To bring database window to the front | F11 |
| To cycle between open windows | CTRL + F6 |
| To restore the selected minimized window when all windows are minimized | ENTER |
| To open a new database | CTRL + N |
| To open an existing database | CTRL + O |
| To close MS Access | FLT + F4 |
Change Directions in MS Excel
The default behavior of the Enter key in MS Excel drives some folks crazy. When you click on Enter, some people would prefer that the cursor move to the next cell on the right, while others prefer the cursor move downward. Fortunately, MS Excel can accommodate these preferences and more.
To change the way MS Excel reacts after you click Enter, follow the steps below:
- Click on Tools | Options.
- Click on the Edit tab.
- Click the Move Selection After Enter check box to activate the direction drop-down list.
In the drop-down list, select from the following options:
- Down
- Right
- Up
- Left
If you prefer that the cursor stay in the active cell when Enter is clicked, deactivate the check box for the Move Selection After Enter option.
After you have changed the way MS Excel reacts after you click Enter, this change will remain in effect for all new and existing workbooks.
Change Numbers in MS Word Document Captions
When you use the Caption feature in MS Word, a label and number can be assigned to each figure in your document. By default, MS Word assigns each figure a number beginning with number 1 and so on. However, if you do not want to use this number format for the figures, you have the option to change it.
Follow the steps below to change the number format for a caption:
- Launch MS Word.
- Select the caption you want to change.
- Click Insert | Reference | Caption.
- From the Caption dialog box, click the Numbering button.
- Use the drop-down arrow beside Format, and select the number format you would like to use.
- Click OK.
- Click OK.
Pretty simple once you know how isn't it?
Included in the Premium Newsletter:
- Permanently Delete in MS Outlook
- Use Slide Finder Feature in MS PowerPoint 2007
- Open Two MS Excel Workbooks with the Same Name
- Change Time Increments in MS Outlook
- Permanent Watermarks in your MS Word Documents
Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.