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

Carol's Corner Office

Monthly Archives: January 2020

Carol’s Random Ramblings…

Posted on by Posted in Carol's Ramblings

Well, the holidays are over and I survived them!  Christmas is my absolute favorite time of year!  Having said that, the older I get the tireder I get.  It’s a lot of work setting up all those decorations for sure.  But I do love seeing my grandchildren’s little faces light up when they see them.  That makes all the effort worthwhile for me.

Of course we all celebrate our holidays in different ways, but whatever your persuasion, I sincerely hope that each and every one of you had a peaceful and love filled holiday surrounded by your loved ones. And I hope you all received all the Christmas hugs you were wishing for.

So, we are now definitely into the New year and what a year it has started out to be!  All I will say on that subject is, please, pray for peace in our world.  I am entirely sincere in that request.  We need more peace and love in our existence., now more than ever.

I think you will find this month’s tips and tricks worth waiting for – I hope so anyway.

Until next time, take care of you!

Carol-signature

How To Create Super Fast Charts in Excel

Posted on by Posted in Excel 2016

Yes, of course, you can use the Chart Wizard to create your chart, but there are some occasions when going through even the Wizard seems too long. So if you feel the need for speed, this tip is for you!

Follow the steps below to learn how:

  1. Select your table on which you would like your chart to be based.
  2. Press F11.

It does not get any faster than that! Excel will insert a new Chart worksheet before your current worksheet, and base the chart on the data in your table and the default chart type you have set up. You can now customize your chart any way you like and work on it as you normally would.

Should you want to create an embedded chart, follow the quick step below:

Press Alt+F1 in step 2 in place of F11.

Cool beans right?

How to Unhide Hidden Text in Word

Posted on by Posted in Word 2016

For whatever reason, some folks have documents that are full of hidden text. Then comes the time when they want to make that text un-hidden. What to do?  Well the short answer is  use Find and Replace.

Follow the steps below to learn how:

  1. Press Ctrl+Home to go to the start of your document.  You don not actually have to do this, but I find it  makes it easier to find and replace.
  2. Press Ctrl+H to display the Replace tab of the Find and Replace dialog box.
  3. Click the More button, if it is available.

find-and-replace

 

  1. Be certain there is nothing in the Find What box, and that your cursor is in the box.
  2. If you see the No Formatting button, click it.
  3. Click the Format button and select Font to display the dialog box

font

 

  1. Click the Hidden check box. A check mark should appear in the check box.
  2. Click OK. The Find Font dialog box will disappear, and the word Hidden will appear under the Find What box.
  3. Be certain there is nothing in the Replace With box, and that our cursor is in the box.
  4. Click the Format button and select Font to display the Replace Font dialog box.
  5. Click the Hidden check box two times. The check box should be empty.
  6. Click OK. The Replace Font dialog box will disappear, and the words Not Hidden will appear under the Replace With box.
  7. Click Replace All.

This should find all text in your document that has the Hidden attribute. It then will turn off the attribute, so that your text is not hidden any longer.

 

 

How To Create A List In A Word Document

Posted on by Posted in Word 2016

If you find the need for a list in your document, Word will very quickly and easily accommodate you.

Follow the steps below to learn how:

  1. Key in your list, only pressing Enter at the end of each item in your list.
  2. Select all the items in your list.
  3. Be certain  the Home tab of your Ribbon is displayed.
  4. To create a numbered list, in the Paragraph group click the Numbering tool.
  5. To create a bulleted list,  in the Paragraph group, click the Bullets tool .

Pretty darn easy huh?

Subscribers: Tables in Word 365

Posted on by Posted in Subscribers Word 2016

As I am sure you know by now, the table options in Word are plentiful and very flexible by default. You know how it is, you create a table and every single time you spend time modifying the properties.  If it seems you use the same properties for each table you create, you can save

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 Hyperlink a Document in Outlook

Posted on by Posted in Subscribers Outlook 2016

Creating a hyperlink to a document in a shared location (i.e., network drive, Sharepoint library) can be a very effective way to email a document to one of your colleagues. A hyperlink, unlike an attachment, will not create a copy of the file, take up excessive real estate in your mailbox, or cause anyone 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 Access God Mode in Windows 10

Posted on by Posted in Subscribers Windows 7

God Mode is the name that was given to an option that has long been available in Microsoft Windows. It gives you quick access to most of the applets and commands from the Control Panel. So God Mode or Windows Master Control Panel is a very useful time saver that can save you the aggravation

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: Automate Recurring Tasks & Filing With Quick Steps

Posted on by Posted in Subscribers Outlook 2016

Using Outlook 365 to automate repetitive tasks (i.e., inviting a group of people to meetings or forwarding emails to a group). Also, you can automate sequences to perform functions such as deleting messages or moving them. Quick Steps apply multiple actions at the same time to email messages. This helps you quickly manage your mailbox.

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 Recall An Email in Outlook 365

Posted on by Posted in Subscribers Office 2016

As you may or  may not know, Microsoft Outlook works like an email client and has myriad, robust tools for use by individual, as well as group scheduling, and task lists, and reminders. The tip below will give you more productivity in Outlook than you ever dreamed was possible. Let's start with how to recall

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!