[April 15, 2010]
We have just celebrated Easter here and are now fully into Spring. It is so nice to go outdoors without layers of sweaters and jackets!
I am endeavoring to walk ten thousand steps every day, which doesn't sound like much but it turns out to be five miles. I always get to work forty-five minutes to an hour early and so I am now using that time to walk. I was really surprised by how many steps my little half hour walk used. I find it is very relaxing to start my day in this manner. I noticed the tulips, daffodills, lillies of the valley, etc. that I have never noticed before. I was so engrossed in nature that I didn't even notice the cars on the road! When I got back to the office I felt energized and ready to settle down and work! It is difficult to walk ten thousand steps a day when you are sitting at a desk, but at least I am now a lot more aware of just how inactive I am and I can do something about it. No more elevators for me! I will take the steps and I walk up to the floor where I parked my car as well.
Make sure you set aside even just a little bit of time to get outdoors and clear the cobwebs from your brain. It will make you feel good and you will sleep better as well. Whatever you are doing to celebrate Springtime, I hope you are enjoying it to the fullest.
Please join me now in welcoming James, John, Brian, Mike, and Ken 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
ActiveWords - Free Program!!!
Alt + V for Paste Special in MS Word - All it takes is a macro!
Color Even Numbered Rows in a List in MS Excel - Your way again!
 |
|
ActiveWordsReview
Buzz Bruggeman, one of the team members of ActiveWords contacted me and asked me if I would like to take a look at their product and review it. Well I did and boy am I glad! I don't know how I got along without it! It is such a TIME SAVER and you all know how I feel about that!
You all know that I rarely recommend products in this newsletter unless it is one that I deem to be worthy of the time and space it takes in the newsletter. It has to be good enough for me to share with my loyal subscribers.
This is one of those times.
ActiveWords is an application that allows users to name and directly access all their favorite places from any context at any time. For example, whatever I am doing on my computer, I can simply type FB and I am immediately taken to Facebook. I can key in Word and MS Word will open for me. The list goes on and on. You are only limited by your own imagination!
With this handy little application you no longer have to stop and click on the desktop icon to open your Internet browser. You can create your own names for anything that you want it to do for you. It works across different device platforms too! The same words produce results on your PC, laptop, Palm device, mobile phone, etc.
You have to try this program to believe it. And best of all, it's FREE! Sure, once you use the free version, you will most likely want the full version but guess what? It is very reasonably priced. Wait until you see how much time this dandy program will save for you. But wait - there's more! There are even free services that you can download to complement the program!!
You owe it to yourself to hop on over to ActiveWords and download your copy today and when you do, please be sure to tell Buzz that Carol sent you!
Once you download your free copy, please let me know the different things you use it for. Buzz has told me that there may be three free full versions for the most clever and innovative uses of ActiveWords so let your imaginations run wild!!
Alt + V for Paste Special in MS Word
Want to use Alt + V for Paste Special in MS Word? Piece of cake!
Follow the steps below:
- Click on Tools | Macro | Macros.
- The Macros dialog box will display.
- In the Macro name box, key in PasteUnformattedText.
- Make sure that All active templates and documents is displayed in the Macros in list, and then click Create.
- The Microsoft Visual Basic Editor is displayed.
- Directly above the End Sub statement in the PasteUnformattedText subroutine, key in the following:
- Selection,PasteSpecial DataType:=wdPasteText.
- On the File menu, click Close and Return to Microsoft Word.
Now you need to tell MS Word to run the PasteUnformattedText macro each time you click on Alt + V.
- Click on Tools | Customize.
- Click the Keyboard button.
- Make sure the Save changes in box displays the Normal.dot.
- In the Categories list, click Macros.
- In the Macros list, click PasteUnformattedText.
- Click in the Press new shortcut key box.
- Click Alt + V simultaneously.
- Click Assign.
- Click Close and then Close again.
That's it! You're done!
Color Even Numbered Rows in a List in MS Excel!
Want to color your even numbered rows in your MS Excel List? Follow the steps below:
- Select a cell in the region and click Ctrl + Shift +* or Ctrl + A t select the Current Region.
- From the Format menu, select Conditional Formatting.
- For Condition 1, select Formula is and insert the following formula in the Formula box:
- =MOD(ROW(),2<>0
- Click Format and select the Patterns tab.
- Choose any color and click OK two times.
Included in the Premium Newsletter:
- Display Saturday and Sunday individually in MS Outlook
- Google Wonder Wheel
- Edit Custom Dictionaries in MS Word
- Align Decimals with Variable Decimal Decimal Places in MS Excel
- Add Folders to your Bookmarks Toolbar in IE and FireFox
- ActiveWords Review
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.