Categories
Excel 2010

How to Use Numbers for Column Headings Rather than Letters in Excel 2010

By default, columns are referenced as letters in Excel. It doesn't have to be that way though! You can reference your columns by number rather than letter if you so choose.  It's called an R1C1 style reference and it is more complicated, but it does serve a purpose and has often been needed for complex […]

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 2010

How to Turn Off Insert Options in Excel 2010

In Excel there is a feature that will  allow you to modify the way in which you insert rows, columns or cells in your worksheet. When you insert any of these, Excel will display a small, button near the inserted row, column, or cell. The button,is called called Insert Options and it has a small […]

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 2010

How To Clear Cells Quickly and Easily in Excel

Everyone knows I love to save time and keystrokes and this is a tip that does both for you! Follow the steps below to lean how Once you have a range of cells selected, just grab the Fill handle int he bottom-right corner of your selection and drag it back over your selection. As 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 2010

How to Quickly and Easily Zoom in Excel

If you spend a lot of time zooming in your Excel worksheets I am sure you will agree that it becomes very tiresome very quickly! It also uses a lot of time which we all know I hate to do! So, if you have a mouse with a small wheel between the left and right […]

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 2010

How to Display a Hidden First Row in Excel

Excel is such a great program and it makes it so easy to hide and unhide rows in our worksheets, using the menus. What isn't very easy is displaying a hidden row if that row happens to be the first visible row in your worksheet. (i.e., if you hide rows 1 through 5 of your […]

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 2010

How to Protect your Worksheet Formatting

You can easily protect the formatting of your worksheet without it affecting your data or text. Follow the steps below to learn how: Select all the cells in your worksheet. On the Home tab or your Ribbon in the Cells group, select Format Cells to open the dialog box. Make certain the Protection tab has […]

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 2010

How to Sort or Filter Using Conditional Format Results in Excel

Supposing you had values in Column A of your worksheet and a list in Column B. There is a conditional format that make any value in Column A turn red if it is also in Column B and you want to sort or filter by that result. This is not terribly difficult to do. All […]

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 2010

How to copy Filtered Data From A Table in Excel

Copying data from a table is fairly easy because you can do it using the copying method that you have been using for practically forever in Excel. Follow the steps below to learn how: Filter your table as you normally do , so that it displays only the records you wish displayed. Select the table […]

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 2010

How to Get Help with Worksheet Functions in Excel!

There are times when you need a function in Excel and you know what it has to do with and perhaps part of the name, but just cannot remember the full function name!  I know as I age it happens to me more frequently than I care to admit! If you, like I, have the […]

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 2010

Adjust the Width of your Columns in Excel

Sometimes you inherit an Excel worksheet from one of your colleagues and discover that you cannot see all of the data that has moved outside the cell and is hidden. In this instance, you can very quickly adjust the width of your column (columns) using your mouse. Simply select the column and move your cursor […]

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!