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

Subscribers: How to Use Mail Merge in Word 2016

A mail merge in Word combines a prepared letter with a mailing list, so your bulk mail is personalized before it is sent out.  For instance, you may be part of a company that has a list of  clients and you would like to advise them about an upcoming sale. In this instance, your mailing […]

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

How To Lock a Field in Word

Many of the tips I post rely on the use of the special fields available in Word. Many times, these fields are updated, automatically, when you make changes in a document or actually print the document. There may be times when you would like to make sure a field does not get updated. You can […]

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

Subscribers: How To Get Rid Of The CTRL + Click Message

In previous issues I have told you how to use the ScreenTips feature in Word to create pop-up screen help in your documents. In some of the later versions of Word, when you move your cursor over a hyperlink, you receive  a message that says Use Ctrl+Click to Follow Link, which can be distracting. Fortunately, […]

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

Subscribers: How to Set Up an Out of Office Vacation Auto-Reply in Outlook 2016

Nowadays taking your mail with you is so very easy! Apparently, what folks think is difficult is leaving it behind! We all know that wherever you wander, taking all your e-mail with you is oh so easy, although perhaps leaving it home is the wisest choice. Outlook makes it very simply for us to take […]

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!