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

Carol's Corner Office

Category Archives: Subscribers

In-depth Microsoft Office articles with extra content. Restricted to paid members only.

Subscribers: How to Correct a Capital Mistake in Excel

Posted on by Posted in Subscribers Excel 2010

How many times have your fingers been flying over your keyboard and then you happen to glance down and discover that Caps Lock is on?  Isn't that so aggravating?? Fortunately, Excel can catch my error for me - IF I tell it to! Follow the steps below to learn how: On your Ribbon, Click 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!

Subscribers: How to Quickly Change Tab Alignment in your Documents

Posted on by Posted in Subscribers Word 2010

As most of you know, Word will allow you to insert many different tab types in your documents. If you use styles (and I hope you do!) changing the alignment of tab stops in certain types of paragraphs is very easy. However, if you use non-style formatting, it can be a bit more difficult. Supposing

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 Shade Cells Based on Odd and Even In Excel

Posted on by Posted in Subscribers Excel 2010

When your worksheet has a range of cells with a series of values, you may choose to use a different format to show the difference between the odd and even values. The method to do this is using the Conditional Formatting feature. Follow the steps below to learn how: Select the cells that contain odd

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 Add an Ellipsis at the Beginning of Paragraphs

Posted on by Posted in Subscribers Word 2010

Suppose you have a document that you are working on that has multiple paragraphs that begin with incomplete sentences. This happens often in legal, academic and technical documents. It normally is very apparent where these incomplete sentences are placed because the paragraph starts with a word with a lowercase letter rather than uppercase. So how

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 Deal with Long Lines in Your Address Labels

Posted on by Posted in Subscribers Word 2013

Word will create address labels for you from data that has been stored in a different source (i.e., Access database or Excel workbook). Essentially, Word takes the information from those sources and places it into the format that you designate in Word.  Because it has been put into Word format, it it now possible that

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 Make Comments Visible Only when Hovering Over a Word or Phrase

Posted on by Posted in Subscribers Word 2010, Subscribers Word 2013

As you may or many not know, in Excel you can add a comment to a cell that is only visible when someone hovers their mouse over it. But can you do it in Word as well? The short answer is no, it does not happen by default.  But, there is a "kinda" "sorta" was

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 Insert Serial Numbers in your Word Document

Posted on by Posted in Subscribers Word 2010

A client asked me recently how she could put serial numbers in her documents.  The catch was that the serial numbers were unique (i.e., B2398, B 3487, B4576, etc.) Let's assume that you know what serial numbers you need to use for your document. If that is the case, the most efficient method to do

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 Use a Custom Drop-Down List for Choices in your Worksheet

Posted on by Posted in Subscribers Excel 2010

There are myriad reasons why one would want to control a user's input in a worksheet.  My number one reason is that it saves time and keystrokes and everyone knows how much I love that! Another reason is that it will limit the choices and you will then be certain to get the data that

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 Use Slide Design Templates in PowerPoint 2103

Posted on by Posted in Subscribers PowerPoint 2013

PowerPoint makes it easy for you to create a streamlined presentation that always looks as if it has been professionally done. One way in which they do that is by providing you with design templates, which are formatted themes with their own backgrounds, fonts and styles. They even have color schemes that you can select

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 Find All Merged Cells on your Worksheet

Posted on by Posted in Subscribers Excel 2010

Lots of folks used merged cells in their worksheets and then can definitely be helpful but many times, those helpful merged cells can cause you untold heartburn when selecting ranges, sorting and lots of other functions we use in Excel every day. Even if you do not use merged cells because you once experienced 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!