Categories
Subscribers Excel 2013

Subscribers: How to Quickly Navigate in Excel

Say you have a large Excel Worksheet and you need to be able to access rows that are buried way down in quickly. Fortunately, there is a built in method to accomplish this task. Follow the steps below to learn how: Press F5 which will display the Go to dialog. Click OK. What about named […]

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

Subscribers: How to View, Arrange, Hide All Shapes, Etc. in Excel

As you may already know, in Excel, you are able to add shapes, images, object, photos, etc. to your worksheet. The issue is that at times these items can be hidden or can overlap each other so that you are unable to see/find them. There is, however, a great tool that will allow you 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
Subscribers Excel 2013

Subscribers: How to Import and Refresh Data from the Web

Have you ever had the need to update a worksheet using data that you found online? Well if you have, you can now end the agony of repeatedly navigating to the web page, copying the data and then pasting it into Excel. Now you can use a one time process to bring up-to-date information from […]

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 Excel 2013 Subscribers Excel 2016

Subscribers: How To Add a Drop-down List to a Cell

You can create a simple list for your users to select from in your worksheet. This will greatly reduce errors because you are limiting input from the user's keyboard and makes things quick and easy for them as well. Everyone loves quick and easy right? I know I do! You only need to things for […]

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

Subscribers: How To Delete A View In Excel

I believe it is a truism that whenever you add something, you will later want to delete it. When you have finished with a project or you do not have need for a particular view, you will want to get rid of it. Follow the steps below to learn how: On your Ribbon, display 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
Subscribers Excel 2013

Subscribers: How To Move Part Of A Footer Down One Line In Excel

Suppose you have a custom footer that you would like at the bottom of all the pages in your worksheet. Left-justified in the footer, you would like the full path name for your worksheet, and centered you would like a page number in the format of Page X of Y. Because a full path name […]

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

Subscribers: How To Highlight Cells Containing Certain Text In Excel

The conditional formatting feature in Excel can be used to draw attention to cells that contain specific text in in your Worksheet. Suppose, you have a range of cells and you would like to know which ones contain the letters "carpe." Highlighting comes in very handy at this point. Follow the steps below to learn […]

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

Subscribers: How To Insert A Watermark Behind Merged Cells in Excel

I saw an article recently regarding this topic.  I had never really thought about doing this before, but it is nice to know that if I needed to, I could probably work it out. I thought it prudent to share this information with my subscribers in case you had a need like this.  This particular […]

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

Subscribers: How to Clean Up Your Macro List in Excel

Whenever you use the macro recorder to record a macro, Excel assigns it a name of MacroN.  The N is the next available macro number. So  the first macro recorded would be Macro1, the second would be Macro2, etc.  Excel will allow you to pick a different name when you record the macro,  most folks […]

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

Subscribers: How to Make Better Use of the Heading Space in Your Excel Table

You may have noticed that the column headings you key into your table are very often wider than the data contained in your column. As a result, your printout could be wider than is necessary and sometimes so wide that it will not print on a single sheet of paper. There is one method 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!