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

Carol's Corner Office

Category Archives: Subscribers Excel 2007

Subscribers: Formatting Ranges as Tables in Excel 2007

Posted on by Posted in Subscribers Excel 2007

When you format a range as a table in Excel, you receive the benefit of table styles, which allows you to apply several formatting attributes at one time. Follow the steps below to format a range as a table: Click in or select the range you would like to use as your table (it does

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: The Table Feature in Excel 2007

Posted on by Posted in Subscribers Excel 2007

The Table feature was a great addition to Excel 2007. A lot of folks aren't even aware of it, much less impressed by it. A lot of you might even opine that a worksheet is just a table anyway. The answer is no. When you format an Excel worksheet as a table, it extends 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: Multi-Column Data in a Text Box in Excel 2007

Posted on by Posted in Subscribers Excel 2007

As I am sure you are all aware, text boxes are great for adding comments and other information to your worksheets. There is also the flexibility of moving them around and keeping them from printing if you like. There are, however, some instances where text boxes just don't do the job for you. Suppose you

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: Calculate Age in Excel 2007

Posted on by Posted in Subscribers Excel 2007

A subscriber wrote to me recently asking if there was a way in which MS Excel could calculate ages for her. It seems she works in the Human Resource Department of a rather large law firm and the firm has a form that must be filled out for every new hire providing their date of

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: Change Default Chart Colors in Excel 2007

Posted on by Posted in Subscribers Excel 2007

Many times subscribers have written to me to inquire how to change the default color of charts and graphs in MS Excel. The reasons are myriad. Some folks want to use the company logo or school color scheme and others just want something a little more "in your face." In MS Excel 2007 you will

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: Automatic Recalculation in Excel 2007

Posted on by Posted in Subscribers Excel 2007

Recently, a reader wrote to me with the following query: I have an Excel Workbook that includes several worksheets. As I move from sheet to sheet within the workbook, I would like the value of one particular cell in the first sheet to be visible in my status bar so that I can watch it

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: Drop-Down Lists in Excel 2007

Posted on by Posted in Subscribers Excel 2007

There are times when you would like to restrict the data that is being entered into a range of cells in MS Excel to a predefined list of values. This makes it more efficient and much easier for the person who is entering the data. Not only that, but it really narrows the margin for

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: Locking Cells in your 2007 Excel Spreadsheet

Posted on by Posted in Subscribers Excel 2007

Protecting your data in MS Excel 2007 is a two step process. All cells in an MS Excel Spreadsheet are locked by default.Step one locks or unlocks specific cells within your spreadsheet and step two applies the Protect Sheet option. Until you complete step two of the process, all of your data is vulnerable to

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: Number Formatting in MS Excel 2007

Posted on by Posted in Subscribers Excel 2007

Sometimes within your worksheet, you may have different, non-standard numbers. Perhaps you have dates and times and currency numbers. If you want MS Excel 2007 to interpret these different, non-standard numbers the way that you do, you will need to format the number properties in the cell in which they appear. Follow the steps below

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: Display Negative Times in Excel 2007

Posted on by Posted in Subscribers Excel 2007

My son-in-law came to me recently with a problem he was experiencing in MS Excel. He is a director in his company and is charged with keeping track of his employees time. He wanted to be able to display a negative time in his MS Excel spreadsheet. I have to tell you - I had

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!