Microsoft Office Tips, Tricks, and How-to's to help you use MS Office like a pro!

Carol's Corner Office

Monthly Archives: August 2016

Subscribers: How Cool is Windows Notepad? Turns out VERY!

Posted on by Posted in Subscribers Microsoft Windows, Subscribers Windows 7

I don't know anyone who is enthralled with Windows Notepad. Most folks figure it is just a basic program and don't bother with it much at all. Turns out that Notebook is a whole lot more robust than one would think at first glance! If you want to learn more about this handy little program,

Read More...

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!

Do Some Math With Dates Using Your Calculator in Windows

Posted on by Posted in Microsoft Windows

Most folks are not aware of half of the things you can do using your Calculator in Windows. Below is but one of the cool uses.

For planning anything date related, the date calculation function is great. It allows you to calculate the difference between two different dates. For instance if you were born on August 17, 1957, this function will calculate and tell you that on August 17, 2016 you were 21,559 days old! I am not sure that information would be very valuable to you, but there are many other uses for this function, such as wedding invitations, vacations, etc.

Date Calculation

This function will also allow you to add or subtract days from a specific date. Say you have a 4 month deadline – this tool will allow you to figure out what that date will be. Warranties – you can figure out how many days are left!

I am certain you will find lots of uses for this!

Subscribers: How to Show Your Tech Person What Happened Step By Step

Posted on by Posted in Subscribers Windows 7

This is a little known feature in Windows - even a lot of Information Technicians are not aware of this. The Windows Steps Recorder can provide your IT person with a detailed list of everything you did up to and including the when your issue began. This is a pretty amazing feature! The Steps Recorder

Read More...

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!

Subscribers: How To Do a Global Find & Replace To Change Color Highlight Color

Posted on by Posted in Subscribers Word 2013

So my good friend Anne, that I have worked with for years now, had a Word issue yesterday.  She had vetted a transcript and highlighted the salient parts for her attorney so he could refer to them during a trial. Her problem was that when she printed the highlighted transcript, the highlighting did not show

Read More...

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!

Carol’s Rambling…

Posted on by Posted in Carol's Ramblings

Summer is quickly approaching it’s end and it makes me sad.  Oh, I know it will stay warm for a while yet but I like the promise of summer, getting outdoors and doing things you cannot do when it’s cold and planting and watching the fruits of your labor growing – all of that and more!

I have had a very busy summer.  I promised myself that I would get to the office early and take a two mile walk before my work day started every morning and I have pretty much stuck to that all summer long.  I intend to keep it up until it is so cold I cannot do it.  I feel better and look better.  I haven’t really lost any pounds but something went somewhere because I have gone down a size (always a good thing).  I vacationed with the kids and the grandkids and visited back and forth with them.  I went to see bands perform and I took hikes.  All in all, I have had a really nice summer and am grateful for it.

I have also knitted a  bunch of hats for babies at the local hospital and for the homeless.  I try to remember those that are not as fortunate as me and I hope that you all do as well.

I think you will find some very useful tips in this newsletter.  If you have a useful tip, let me know about it.

Until next time, take care of yourselves and each other.  Remember we aren’t in this alone!

 

Carol-signature

How to Quickly Select Entire Columns or Rows in Excel Worksheets

Posted on by Posted in Excel 2013

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 rows.

Follow the steps below to learn how:

  • To select the entire row where your active cell is located, simply depress your Shift key and click on your Spacebar.
  • To select the entire column where the active cell is located, depress your CTRL key and click your spacebar.

It matters not which cell is active when you do this.

  1. You can also select multiple rows and columns using your keyboard:
  2. If you want to select rows 1 through 5, use your arrow key to move to any cell in row 1.
  3. Now depress your Shift key and use the down arrow to select down to row 5.
  4. Click Shift + click Spacebar.

The entire rows of 1 through 7 will be selected.

To select columns A through E, use your arrow key to move the active cell to column A.

  • Depress your Shift key and press your arrow key to select over to column E.
  • Click CTRL + Spacebar.

Now columns A through E will be selected.

Subscribers: How to Use the Spike in Word – A More Powerful Clipboard!

Posted on by Posted in Subscribers Word 2013

Copy and Paste is such a nice feature and easy to use as well, but it does have its limitations, that being its one at a time Clipboard nature. The Spike, on the other hand, will help you to gather data from multiple areas in your Word document and then paste all the content to

Read More...

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!

Subscribers: How to Use Portrait and Landscape in your Word Document

Posted on by Posted in Subscribers Word 2013

Ok, this is an old tip, but one that definitely bears repeating as I get many, many inquiries on this subject. There are many times when you may need to know this. Suppose you are creating a handbook for machinery or you are writing a technical manual or article and you need to include schematics,

Read More...

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!

Subscribers: Create and Generate Unique Numbers for Worksheet in Excel

Posted on by Posted in Subscribers Excel 2013

You might at some point want Excel to generate a unique number for your worksheets. Suppose, were creating  forms such as statements, invoices, etc., and you want a unique number for each form. And you also want  Excel to remember the number from one session to the next. There are more than one way to

Read More...

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!

Subscribers: How to Make your Bookmarks Bold in your Word Documents

Posted on by Posted in Subscribers Word 2013

If you have a lot of bookmarks in your document, you may want to make them bold so that they are easier to see. Fortunately, this is fairly easy to do. Follow the steps below to learn how: Display the Word Options dialog box by clicking the File tab of your Ribbon and then click

Read More...

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!