Microsoft Office Tips, Tricks, and How-to's to help you use MS Office like a pro!

Carol's Corner Office

Monthly Archives: April 2017

Carol’s Rambling

Posted on by Posted in Uncategorized

Well hello again.  Let me wish you happy Easter or Passover or whatever way you worship.  I am not trying to proselytize, I simply want to share my holiday with you whatever your persuasion!

I absolutely love this time of year!  Everything is becoming green again and beautiful blooms are everywhere you look.  The weather is warmer and the sun is shining….what’s not to like right?

I am so glad to be able to exercise outdoors again!  I would much rather walk on a scenic trail than on a treadmill inside any day!

I hope you enjoy the articles this month and I hope you are enjoying this lovely Spring weather.  Please remember to help those less fortunate that yourself and be kind to each other.  We need all the kindness, mercy and compassion we can muster nowadays.

Until next time, take care of YOU!

How to Enter a Slashed Zero in your Word Document

Posted on by Posted in Word 2013

On some occasions, you may want to use a slashed zero in your document.  Very often, they are used in technical documents to delineate a zero from the capital letter O.

Should you want to use this character, you have two choices. Firstly, you can find a font that actually uses the slashed zero in it. If you use this character a lot, this is probably the best solution.

Otherwise, follow the steps below:

  1. Place your cursor where you would like the slashed zero to appear.
  2. Click Ctrl+F9 to insert field braces.
  3. Key in eq \o (0,/)
  4. Click Shift+F9 to collapse your field and the slashed zero will appear in your document..

Subscribers: How to Access your QAT Using Your Keyboard

Posted on by Posted in Subscribers Excel 2013

I don't know about you, but I love to customize my Ribbon and my QAT (Quick Access Toolbar).  It just makes life a lot easier for me and it will for you as well should you choose to avail yourself of this feature. It just makes sense when your hands are already on your keyboard,

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: How To Select An Entire Section of Your Document in Word

Posted on by Posted in Subscribers Word 2016

Perhaps you already know that you can click Ctrl+A to select all the text in your entire document. But, suppose you want to select all the text in a particular section of your document? Is there a shortcut to select just a single section? A section is defined as the portion of a document between

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: How to Triple Space your Document for Easier Editing in Word Before You Print

Posted on by Posted in Subscribers Word 2016

I don't know about you, but I have worked with people who think it is their job to edit and correct everything they have ever given you to transcribe. I have done letters in my time that had a sentence ten lines long. So of course, I would give it back after I had transcribed

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

How to Determine the Number of Paragraphs in your Word Document

Posted on by Posted in Word 2013

Very often macros are used for processing a document. It is fairly common to have a macro step through all the paragraphs in your document and make changes based on the information in the paragraph.

If you need to step through all the paragraphs in a document, it is helpful to find out how many paragraphs there are.

The easiest method for you do that in a VBA macro is using the Count property with the Paragraphs collection, as follows:

iParCount = ActiveDocument.Paragraphs.Count

The Paragraphs collection contains all of the paragraphs in your document, each in its own object. The Count property returns a value indicating how many objects (paragraphs) are in the collection. In the example above, this value is assigned to the iParCount variable. You can then use this count in doing any processing you need to.

Please note,  that paragraphs can be empty in Word. If you key in some information and then click the Enter key two times, you have just created an empty paragraph with that second Enter click. This increases the paragraph count, so it is always good to have your Show/Hide enabled so that  you see non-printing characters in your document if you are trying to figure out how VBA reached the paragraph count  it did. The rule is that each click of Enter will result in a new document paragraph.

Many thanks to Allen Wyatt for the macro in this newsletter!

Subscribers: How to Create Custom Labels in Word

Posted on by Posted in Subscribers Word 2016

One  advantage of using standard labels in Word is that it includes label definitions for myriad different label types. You can select the type of label you would like to use, by number, from the Label Options dialog box. However, you may find that at times you need to create your own label. For Example,

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: How to Print Your Own Return Address Labels

Posted on by Posted in Subscribers Word 2016

Just about every client I have and every business I have worked with uses this  common type of label -  a return address label. Unfortunately, a lot of folks recreate the wheel every time they have a need for a return address label. The good news is, you can quickly print return address labels using

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!