[July 1, 2009]
Ahhh.....July.... Need I say more? I just returned from a very relaxing week in the Outer Banks of North Carolina. I didn't realize how much I needed that vacation! I was just getting into it when it was time to leave! Walking on the beach in evening as the sun sets, swimming in the pool, sipping a glass of wine on the deck while the ocean breeze wafts over you...who would want to leave???
I had a wonderful time, climbed the country's highest sand dune at Jockey's Ridge, saw several light houses, sampled some local cuisine, did some shopping and exploring, swam, relaxed; it was just great, exactly what I needed!
I'm home in time to get my newsletter out to you you, my loyal readers and also in time for my town's local Fourth of July parade and fireworks.
Also, please remember that premium subscribers, receive big discounts on all my books and tutorials and be on the lookout for some new ones! Shouldn't YOU be a premium subscriber? If you find this newsletter useful, please do me a favor and pass it on to someone else that can benefit from it!
Let's get to the tips now!
Table of Contents
Exploding Fields in MS Access - Pretty cool!
Print Cell Comments in MS Excel - Very Easily Done!
AutoComplete in MS Excel? - Not a problem!
 |
|
Exploding Fields in MS Access
When you are editing a data field, you can get an exploded view of the field by clicking Shift + F2.
Print Cell Comments in MS Excel
A subscriber recently wrote to me inquiring how to print cell comments in an MS Excel worksheet.
Most folks think you cannot print your comments in MS Excel. You can print your comments but it is not a very obvious procedure. The option to print cell comments is buried in MS Excel's Page Setup options.
Follow the steps below to learn how to print your cell comments:
- Click on File | Page Setup.
- On the Sheet tab, select one of the Comments options.
- Click OK.
You can now print your worksheet complete with comments.
Afterwards, you can go back to Page Setup and change the Comments option to None.
AutoComplete in MS Excel ?
A subscriber wrote to me last week asking why there isn't an AutoComplete feature in MS Excel.
My reply:
Well it's not exactly AutoComplete but it will do the trick for you. Follow the steps below to learn how:
Whenever you want to repeat data that already appears in a column, simply click:
- ALT + Down Arrow
Quick as a flash you have a list of all previous entries in that column!
Use the arrow keys to select an item and click on Enter.
Pretty cool huh?
Included in the Premium Newsletter:
- Use the Organizer to Copy Styles in MS Word
- Formatting AutoCaptions in MS Word
- Convert Function in MS Excel
- Prevent Users from Resizing an MS Access Form
- StampIt - A Wonderful MS Word Add-In
- MS Access Tips
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.