Categories
Subscribers Microsoft Excel

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

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 […]

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!
Categories
Subscribers Microsoft Excel

Subscribers: Prevent Users from Accessing Locked Cells in 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 […]

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!
Categories
Subscribers Microsoft Excel

Subscribers: Select Non-contiguous Ranges with Keyboard in 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 […]

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!
Categories
Subscribers Microsoft Excel

Subscribers: Show Weekdays Next to Dates in 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 […]

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!
Categories
Subscribers Microsoft Excel

Subscribers: Restrict Data Input to a Specific Area in 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 […]

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!
Categories
Subscribers Microsoft Excel

Subscribers: Useful Excel Function Keys

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 […]

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!
Categories
Subscribers Microsoft Excel

Subscribers: Clean Up Copied Data in 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 […]

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!