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

Carol's Corner Office

Monthly Archives: February 2017

Happy Valentine’s Day

Posted on by Posted in Carol's Ramblings

Well, here we are almost in the middle of February.  It’s kind of drab looking outside and it is definitely cold!  Thankfully we have not have much snow in my neck of the woods, but it is still really, really cold and I find myself longing for warmer climes along with greenery and flowers.

Looks like I will just have to settle for other niceties until Spring gets here, such as Valentine’s day and St. Patrick’s day!  These are both two of my favorite holidays.  I mean who doesn’t like celebrating the people you love and care about right?  And if you get something nice and homemade like cake, pie, cake pops, tarts, or even store bought candy,  you really cannot complain about that!  So I hope you all celebrate Valentine’s day with your sweet patooti and show them how much you care for them

Please don’t forget the folks who don’t have anyone to celebrate with – a random act of kindness is always a good thing.

I hope you enjoy the newsletter.  Until next time, please take care of you!

 

How to Do a Quick and Easy Paragraph Count in your Word Documents

Posted on by Posted in Word 2013

If you want to quickly count the number of paragraphs in your document, there is an easy and straightforward method to accomplish that.

Follow the steps below to learn how:

  1. Be certain you have saved your document.
  2. Click Ctrl+Home to go to the beginning of your document.
  3. Click Ctrl+H. Word displays the Replace tab of the Find and Replace dialog box.

  1. In the Find What box, key in ^p.
  2. In the Replace With box, key in ^p.
  3. Click on Replace All.

Word will replace all the paragraph marks in your document with identical paragraph marks, and display a dialog box indicating how many replacements were made. The number of replacements is the number of paragraphs.

This particular method may not impress you all that much since you can also find out the number of paragraphs in your document by displaying the Statistics tab of the Properties dialog box. BUT, the real power comes in when you want to find out how many paragraphs you have of a certain style. You just need to expand your search a bit.

For example, suppose you have a certain paragraph style that you use only for numbers.

Follow the steps below to find out how many paragraphs you have using that style:

  1. Be certain you have saved your document.
  2. Click Ctrl+Home to go to the beginning of your document.
  3. Click Ctrl+H. Word will display the Replace tab of the Find and Replace dialog box.
  4. Click on More, if it is available.
  5. In the Find What box, key in ^p.
  6. Click on Format and choose Style. Word will display the Find Style dialog box

  1. Select the name of the style you used for your numbers.
  2. In the Replace With box, key in ^p.
  3. Click on Replace All.

The resulting dialog box will indicate the number of replacements made, which are only for those paragraphs that use the numbers style—in other words, you now know how many numbers are in your document1

Subscribers: How to Selectively Change Endnotes to Footnotes in your Word Documents

Posted on by Posted in Subscribers Word 2016

Most of us already know how to change all of our endnotes to footnotes, but suppose you only want to change some of them? Is there is a way to walk through your  endnotes and decide, on a note-by-note basis, if it should be changed to a footnote. Well, the short answer is that there

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 Change the Footnote Separator Appearance in your Word Documents

Posted on by Posted in Word 2016

When you have a very long footnote that will not fit in the space allocated for footnotes on your current page, Word will automatically continue your footnote on the following page. When this occurs, you can specify that Word use a different footnote separator to indicate that the footnotes are a continuation from the previous page.

Follow the steps below to learn how:

  1. Be certain you are working in Draft view by displaying the View tab of your Ribbon and in the Views group, click Draft.
  2. Display the References tab of your Ribbon.
  3. Click Show Notes.

  1. If you have both footnotes and endnotes in your document Word will display the Show Notes dialog box.
  2. Click on the View Footnote Area radio button.
  3. Click OK.
  4. Using the Footnotes drop-down list at the top of the Footnotes window, select Footnote Continuation Separator. The current separator will appear in the window.
  5. Change or delete the separator, as you wish.

When you are finished changing or deleting the appearance of the separator, click Close.

 

Subscribers: How to Specify a Location for Backup Files in Word

Posted on by Posted in Subscribers Word 2013

You can always create backup copies of documents in Word and it is fairly easy to do. Follow the steps below to learn how: Display the Word Options dialog box by displaying the File tab of your Ribbon and then click on Options. Click Advanced at the left-hand side of the dialog box. Scroll down

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 Change the Color Inside a Shape in your Excel Worksheet

Posted on by Posted in Excel 2013

Once you have created a drawing object, you can fill it with your choice of color. Excel makes this very easy to do.

Follow the steps below to learn how:

  1. Select the shape you would like to fill.
  2. Be certain the Format tab of your Ribbon has been selected. Please note that the Format tab will not display unless you select your shape.

  1. In the Shape Styles group, click the Shape Fill tool to display a color menu.

  1. From the color menu, select the color you would like to use.

  1. If you do not see a color you like, click on More Fill Colors to display a wider selection.

Once you have selected  a color, Excel will remove the color menu and fill the interior of your shape with the color you chose. To remove a color, you can repeat the same steps, but in step 4 select No Fill.

Subscribers: How to Place Pictures Inside Shapes in your Excel Worksheet

Posted on by Posted in Subscribers Excel 2013

As you know, Excel will allow you to format the appearance of shapes you place in a worksheet. Once you open the Format Shape dialog box, you can make many changes -  colors, lines, fills, fonts, and other attributes of the shape. One of my very favorite formatting features is placing a picture within a

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 Turn Off Proofing for Superscript in Your Documents

Posted on by Posted in Subscribers Word 2016, Uncategorized

Superscripted text is used for different reasons in a document. For example, it is routinely used for footnote and endnote references. Some folks even use superscripted text for something called reference cues. These are not the same as regular footnote or endnote marks. Say for instance, your document contains the text soyulentgreen.  As you can

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 Prevent Using the Enter Key In Your Word Table Form

Posted on by Posted in Subscribers Word 2016

Ok, suppose you have created a form based on a table format so your entries are neatly aligned. You want to include form fields in both text and number format, adding a maximum field length for each field. This will prevent the person filling out your form from entering text beyond that maximum. However, the

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!