Categories
Excel 2013

How To Have a Worksheet Thumbnail In Your Excel Workbook

Excel provides a couple of settings that control this feature. First, Excel will let you you control saving of the thumbnail image when you first save your workbook or when you use the Save As command to save your workbook under a new name. The Save As dialog box contains a Save Thumbnail check box […]

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 2013

How to Quickly Repeat The Last Action in Word or Excel !

There is a key that is hardly used and yet is a  highly efficient shortcut for speeding up tasks in Word and Excel when you need to repeat the same action, once, twice or many, many times! That key is the F4 key! In Word and Excel many tasks can be repeated instantly by tapping […]

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 2013

How To Quickly Print Without Opening in Excel

Should you need to quickly print the contents of a workbook without opening the workbook yourself manually, you can absolutely do this! Follow the steps below to learn how: Use the Explorer, My Computer or any Open dialog box to locate the worksheet that you would like to print. Right-click on the file. Windows will […]

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 2013

Quickly & Easily Change The Location Of Your Toolbar in Excel

You can quickly and easily change the location of Excel toolbars to whatever works for you! Follow the steps below to learn how: Just double-click your mouse on any portion of your toolbar that is not occupied by a tool. The toolbar will be removed from its normal location and will appear in its own […]

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 2013

How to Sequentially Input Data in your Excel Worksheet

It is not out of the ordinary to need to enter a series of numbers within a range of worksheet cells. For example, you may need to enter a series of numbers in the first ten columns of a certain row, or you may have a need to enter information just in a range of […]

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 2013

How To Replace Dashes With Periods in Excel

Suppose you need to change the appearance of the data in your worksheet.  For instance, you may want to replace dashes in a text string with periods. For example, if you have a phone number formatted as 235-456-7890 you may want to change it to 235.456.7890. This is very easy to do using the SUBSTITUTE […]

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 2013

How to Change the Color Inside a Shape in your Excel Worksheet

Once you have created a drawing object, you can fill it with your choice of color. Excel makes this very easy to do. Follow the steps below to learn how: Select the shape you would like to fill. Be certain the Format tab of your Ribbon has been selected. Please note that the Format tab […]

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 2013

How to Quickly Select Entire Columns or Rows in Excel Worksheets

It is always helpful to know both the mouse and keyboard methods to accomplish the task at hand in Excel. Personally, I like to use my keyboard because that is usually where my hands are already! Below are a few keyboard shortcuts that you will find yourself using all the time - selecting columns and […]

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 2013

How to Get Rid of Empty Rows in an Imported Worksheet in Excel 2013

There are times when you have to work with data in a worksheet imported from another program into Excel.  Normally, it is not a problem to import the worksheet. The problem is that during the process potentially hundreds of extra rows that have no data in them are imported as well. After the import 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 2013

How to Create A Workbook Clone in Excel

There may come a  time when you would like to make a copy of your workbook, without affecting the original. Excel does provide an easy method to do this. Follow the steps below to learn how: Display the Open dialog box. (If you are using Excel 2007, click Office button | Open. If you are […]

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!