[September 15, 2009]
The air is just a tad cooler in my area now, but I know we will still experience "Indian Summer" before it gets really cold. I rather like this time of year because it's warm enough during the day that you do not need a coat and in the evenings usually, the most you need is a sweater but it is nice and cool when it is time to sleep.
My driveway is lined with fallen leaves to be raked but the upside is that the color of the foiliage this time of year is breathtaking. Fall is a lovely time of year when you think of it. Farmers are reaping the fruit of their labors, pumpkins are turning up on front porches, there are bales of hay in the fields, squirrels are scurrying everwhere burying their bounty for the cold winter months. It's really very interesting to watch.
I guess soon I will be kneading dough to make some fresh bread and baking fruit tarts and the like and before you know it the holidays will be upon us and I will be baking cookies right and left!
But let's try to live in the moment and enjoy this transition from Summer to Fall and luxuriate in all the different colors and climes. Remember to take the time to savor every minute!
Please join me in welcoming , Phillip, India, Peggy, Thomas, Nick, Tom, Sylvia, Wilma, Barry, Jeannine, Dorothy, Morton, Edward, Sam, James, Larry, and Philip A. 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
Add Icons to an MS Excel Menu - Save time and keystrokes!
Create Quick Notes with WordPad Scraps - This is pretty cool!
Display Figures Rounded to Thousands in MS Excel - Very helpful in Financial Reports.
 |
|
Add Icons to an MS Excel Menu
You can add an icon to a menu or sub-menu by using the same method you use when you add icons to the toolbars in MS Excel or create new toolbars.
- Make sure the Customize dialog box for toolbars is open.
- Drag the relevant icon to the menu or sub-menu.
- The sub-menu will open to allow you to place the icon there.
When you add icons such as the Custom View icon to the Excel menu, you save toolbar space so you can add smaller icons.
Create Quick Notes with WordPad Scraps
Some folks use Notepad to create quick notes to themselves and then save the file on their desktop. White the process is pretty simple, there is an alternative that you may want to investigate. Creating scraps is as easy as a quick drag and drop operation and there is no need for all the steps involved in naming and saving the file.
Follow the steps below:
- Launch WordPad.
- Create your note.
- Select/highlight the text.
- Drag the selection and drop it on your desktop.
- Close WordPad and click No when prompted to save changes.
Once you drop the selection on your desktop, Windows XP recognizes the selection as an OLE object from WordPad and creates a scrap, complete with a special icon with a default title name of Scrap.
To make it easier to recognize, you can rename the scrap. When you want to view your note, just double-click it and WordPad will open the Scrap.
Display Figures Rounded to Thousands in MS Excel
E easily changing the Style in the Style box, allows you to very quickly change the presentation of numbers in any report displaying and printing reports with figures rounded to the thousandths.
Follow the steps below to apply a Style:
- Add the Style box icon to the Formatting toolbar.
- Create a new Style and name it Round To Thousands.
- Select the columns containing the numbers to round.
- From the Style box, select Round to Thousands.
Included in the Premium Newsletter:
- Import an NFL Football Schedule into MS Outlook Calendar
- Add Symbols to AutoCorrect in MS Word
- Quickly Send Files as E-mail Attachments in MS Office
- Draw, Align and Resize Objects with Cell Borders in MS Excel
- Change the Default Paste Setting in MS Word
- Use Copy or Move Text Keys 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.