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

Carol's Corner Office

Category Archives: Subscribers Microsoft Excel

Subscribers: Turn the Legend On or Off in your Excel Charts

Posted on by Posted in Subscribers Microsoft Excel

As you know, when you create a chart in Excel, a chart legend is automatically created right along with your chart depending upon which type of chart you are creating. It doesn't have to be that way. You have a choice. Follow the steps below to learn how: Click once on your legend to 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: Prevent Users from Accessing Locked Cells in Excel

Posted on by Posted in Subscribers Microsoft Excel

There are many of us who work in an office environment creating custom workbooks in MS Excel that our colleagues update.We protect our worksheets and only unlock the necessary input cells so that our colleagues cannot accidentally delete or change the formulas and other values. Unlocking the input cells and protecting your worksheets is an

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: Select Non-contiguous Ranges with Keyboard in Excel

Posted on by Posted in Subscribers Microsoft Excel

It is very easy to select non-contiguous ranges using your mouse in Excel. We all know how to do that. However, it can be another story if you are only using your keyboard. This article will tell you how to do it! Just about everyone saving the neophytes in Excel, know 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: Show Weekdays Next to Dates in Excel

Posted on by Posted in Subscribers Microsoft Excel

The advantage of using actual date values in Excel is the myriad possibilities you are afforded with Custom Number Formatting. One of these is displaying weekdays next to dates. Below are two options using Custom Number Formatting that will allow you to display weekdays next to the dates in your MS Excel worksheets. For Weekdays

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: Restrict Data Input to a Specific Area in Excel

Posted on by Posted in Subscribers Microsoft Excel

There are a couple of ways to restrict persons using your Excel worksheet to a specific range. Why would you want to do this? Well the first thing that comes to mind is that you only want to allow data input in one specific area to prevent unwanted changes in your worksheet. I am sure

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: Useful Excel Function Keys

Posted on by Posted in Subscribers Microsoft Excel

You all know by now that I am the queen of saving time and keystrokes. If there is a more efficient and useful way of performing a task, I want to know about it. By extension, I want you YOU to know about it as well. So take a look at all the time savers

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: Clean Up Copied Data in Excel

Posted on by Posted in Subscribers Microsoft Excel

There is a fairly efficient method to clean up the weird little characters that you sometimes bring along when you have copied or imported data into your spreadsheets. There is a little heard of function in MS Excel called, appropriately enough, the Clean function and that is what you use to clean up those weird

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!