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

Carol's Corner Office

Monthly Archives: June 2019

Subscribers: How to Insert User Address in Your Document

Posted on by Posted in Subscribers Word 2016

Word automatically maintains several pieces of information regarding you, as a user. One of these pieces is your address, which is changed on the User Information tab of the Options dialog box. Follow the steps below if you would like to automatically insert your user address in your documents: Place your cursor where you would

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 Add a Drop-down List to a Cell

Posted on by Posted in Subscribers Excel 2013, Subscribers Excel 2016

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

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: Some Things You Should Never Do in Word

Posted on by Posted in Subscribers Word 2016

I know that when some folks read this, they will pooh pooh what I have to say. But I can tell you from personal experience, this is something you should NEVER do in Word.  Having said that, if you are creating a Word document that you will retain for yourself and no other person will

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!

Using Two Time Zones In Outlook

Posted on by Posted in Outlook 2016

When you work in a busy office you may find that at times, you are working across multiple time zones.  Obviously, in this situation, it is critical to know the time in the other time zone, so meetings will not be too early or late.

So, instead of fiddling around on the internet trying to figure out your time zones, let Outlook do it for you!  It is quick and easy and you will look like a rock star!

Follow the steps below to learn how:

  1. Simply go to Options | Calendar | Time zones |Show a second time zone.

two-time-zonesEasy peasy!

Subscribers: How Merge & Split Cells in A Table

Posted on by Posted in Subscribers Word 2016

Working with tables in a Word document can, in some instances, be a complicated and tedious task, depending on what you are trying to accomplish. For example, if you are trying to create a form, merging cells is a common thing you may need to do. Follow the steps below to learn how: Select the

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!

Learn Outlook’s Keyboard Shortcuts

Posted on by Posted in Outlook 2016

Just like word and Excel and the other Office applications, Outlook has some unique keyboard shortcuts that will save you time and keystrokes.

Learn the ones you use most and you will be flying through Outlook tasks!

Below are some very useful shortcuts:

CTRL + R – Reply to mail.

ALT + R – Reply to all in email or switch tot he work week calendar view.

ALT + W – Forward email or switch to the weekly calendar view.

CTRL + M – F9 to send/Receive all

CTRL + G – Open the Go to date dialog to jump to any date in your calendar.

CTRL + N – Open a new email.

CTRL + Enter – Send your email.

You can also switch between Mail, Calendar, Contacts, and other items in the navigation plane by tapping CTRL + the place number of the item.

Paste Text Without Formatting In Word 2016

Posted on by Posted in Word 2016

If you reference information from online sources, sometimes when you copy the information directly into Word, there can be issues, such as it does not look exactly the way you thought it would or how you wanted it.

In most instances, you will not want to keep the original formatting of what you are copying, plus it is much quicker to paste it without formatting.

Follow the steps below to learn how:

  1. Open your Word document.
  2. Copy some text from whatever source you like.
  3. Click, the Paste Unformatted to insert the text without formatting. Alternatively, you can right-click where you would like your copied text to appear and select Paste Unformatted from the resulting menu.

It does not get much easier than that folks! AND,you can also set a default so that your text is automatically pasted in that format!

 

Subscriber: How to Prevent Changing Any Data in Excel

Posted on by Posted in Subscribers Office 2016

Ever wish you could just fix it so your worksheet could not be altered or potentially corrupted?  You are not alone!  The good news is that there actually IS a way to do this! It is a great feature to use. The result of the action you about to learn, is that it will prevent

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!