[March 15, 2010]
As I sit here preparing this newsletter for you the rain is falling. Depressing? Well let me just say I am very grateful that it is rain and not snow that is falling! Don't get me wrong, I love nice bright and sunshiny days. I can move mountains when the sun is shining but as the old adage goes "into every life a little rain must fall." I am grateful for the rain because it will nourish the flowers sure to be blooming soon.
I can officially announce that Spring is here in my little corner of the world. The peepers held their first symphony this past week and what a sweet sound it was! Every evening of late as I arrive home I step out of my car and stand very still listening for the sound of the peepers. But this week I heard them faintly even before I exited the car. I just love to listen to their song as dusk is falling. It doesn't take much to make me happy! I love this time of year with such promise of new beginnings and nature so alive with rebirth.
Wherever you are from, I hope that you are enjoying this time of year and all the special times it brings your way. Try to take a moment or two every day to just live in the moment and be thankful for the good things in your life.
For those of you who celebrate, Happy St. Patrick's Day from me and my Irish clan to you and yours!
Please join me now in welcoming D. Roger, Gene, Robert W., Richard, Marcus, Bill, and Tony 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
Spice Up Your Borders in MS Excel - Have it your way!
Colorize your Outlook Messages to Identify Senders - Make it catch your eye!
Rearrange Commands on your MS Outlook Menus, Etc. - Your way again!
 |
|
Spice Up your Borders in MS Excel
It is surprising that more folks don't use the Borders tool in MS Excel. You do know that you can use a border other than that thin black solid line right? There are other options available to you that do not appear on the Borders tool that will allow you to add some glam to your spreadhseet.
Follow the steps below to learn how:
- Click on Format | Cells.
- Click the Border tab.
- There, you will see that you can use different colors for your borders, even in the same cell!
You can create borders of different thicknesses. There are dashed borders to select from too. Heck, you can even create diagonal borders if you want!
Colorize your Outlook Message to Identify Senders
If you need to see e-mail from specific clients quickly at a glance, MS Excel has an option that will make that easier for you.
Follow the steps below:
- Click Tools | Organize.
- In the Ways To Organize Inbox pane, click Using Colors on the left side.
- In the first condition statement, select From in the first drop-down list,
- If you chose a message before starting, the sender's name will appear in the text box to the right. If the name is incorrect, enter the right name or the person's e-mail address.
- Select a color from the second drop-down list.
- Click Apply Color and close the pane.
Now MS Outlook will display all messages, both exiting and new from the person you specified in the color you chose.
Rearrange Commands on your Outlook Menus, etc.
Most folks use a few commands very often and the rest seldom or ever. The good news is that you can rearrange the commands on a menu or toolbar, making your selection process a bit more efficient.
Follow the steps below:
- Click on Tools | Customize.
- Click the Commands tab.
- Click Rearange Commands.
- In the resulting dialog box, select either the Menu or Toolbar option.
- The Controls list box will display the commands, including submenus, as they appear from top to bottom on the menu or left to right on the selected toolbar.
- You can add, delete or move a command up or down or left and right.
- Clicking Add will position the new item above or to the left of the selected command.
- You can also modify the selection by changing its caption and other attributes.
- Select Begin A Group if you would like to add a separator above or beside the selected command.
- Clicking Reset removes all the customization should you want to start fresh.
Included in the Premium Newsletter:
- Separate Text Into Multiple Columns in MS Excel
- Week Numbers in MS Outlook Calendar
- Quickly Enable the Macro Recorder in MS Word and More
- Changing Column Widths in MS Word
- Freezing Rows and Columns in MS Excel - A refresher
- Quickly Remove All Hidden Text 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.