Categories
Excel 2007

Create a Bulleted List in a Single Cell or Text Box in Excel

As you know, you can enter multiple lines within a single cell by simply clicking Alt + Enter, which starts a new line for you. Follow the steps below to learn how to create your bulleted list: Click in the cell or text box where you would like to add bullets. Holding down your Alt […]

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
Excel 2007

Quickly enter Data in your 2007 Excel Worksheet

A really cool shortcut you can use in Excel 2007 allows you to copy data from the cell above the current cell. Follow the steps below to learn how: Click Ctrl + " (quotation mark) Say you enter the number 456 in cell A6. If you then move to cell A7 and click CTRL + […]

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
Excel 2007

Highlight Matching Values in Excel 2007 Quickly

There are many ways of finding matching data in your Excel worksheets, the most versatile of which is filters. Most likely the easiest way is sorting. But if all you really want to do is see the matching values, there is a much quicker way to accomplish this and as you all know, I love […]

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
Excel 2007

How to Create a Pivot Table in Excel 2007

I had an inquiry last week asking me how to create a pivot table in Excel 2007. Pivot tables are a great way to summarize a large amount of data to divulge a new meaning from it. The name is derived from being able to pivot the data in PivotTable view. Follow the steps to […]

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
Excel 2007

How Do I Add a Column in Excel 2007?

I was recently asked how to add a column in Excel version 2007. I don't know too many folks who are thrilled with the Ribbon interface, but once they learn how to navigate it seems to grow on them. Inserting a column or row into an Excel worksheet is easy. Simply select a column or […]

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
Excel 2007

How to Add Pop Up Documentation in Excel 2007

Did you ever wish you could make your worksheets more helpful to the folks who have to use them? Well you can! You can add a pop-up window that will display documentation whenever the cell is selected. Follow the steps below to learn how: Select the cell in which you would like your pop-up to […]

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
Excel 2007

How to Set Default Column Width in Excel 2007

Do you find that you frequently have to resize the columns in your worksheets? Did you know that you can easily set a default column width so that you no longer have to resize your columns? Follow the steps below to learn how: Click on the Home tab. In the Cells group, click on Format. […]

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
Excel 2007

How to Draw Lines in Excel 2007

Excel provides you with tools that allow you to create a number of shapes that you could only make use of through a drawing program. Curiously, one of those shapes is the lowly line. Follow the steps below to learn how to create lines: On the Ribbon, display the Insert tab. In the Illustrations group, […]

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
Excel 2007

How to Enter Dates Without Separators in Excel 2007

If you asked ten different people how they enter dates in their MS Excel worksheets, you would most likely get ten different answers. When you enter information into a cell Excel will try to deduce what type of information you are entering. For example, if you enter a number like 02262011, Excel will assume you […]

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
Excel 2007

How to Turn Off Hyperlink Activation in Excel 2007

If you are like me it most likely bothers you when you enter a URL and it becomes active immediately after you click the Enter key. It always used to bother me until I learned how to prevent it! When you enter a Web address or a LAN (Local Access Network) server address of a […]

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!