Categories
Word 2016

How To Convert Tables To Charts In Word

Have you ever completed a table, had it exactly the way you wanted it, all formatting done – a real work of art – and you hand it in to your boss and he says, “well that’s great, but I would really rather see it in a chart?” Yes, that has actually happened to me. And worse yet, I didn’t know how to easily convert the table to a chart.  How embarrassing!

The good news is that I learned how to convert tables to charts and now I am going to share that information with you.

Follow the steps below to learn how:

  1. Select the table you would like converted to a chart.
  2. Be certain the Insert tab of your Ribbon is displayed.
  3. In the Text group, click the Object tool.
  4. In the resulting dialog box, select Microsoft Graph chart from the list of Object Types.
  5. Click OK to display a graph of your data.
  6. Format your graph to your liking.
  7. Click anywhere outside your inserted graph to continue working in your document.

You may notice that there is a Chart tool in the Illustrations group on the Insert tab of your Ribbon. You might be fooled into thinking that this would work for you just as well as the steps above. It will not.

If you have tried this, you know that the end result will be a generic chart created by Excel and placed directly in your document. Yes, you can also get the same end result if you choose Microsoft Excel Chart in step 4 above.  Word does not base your chart upon the table data you selected it in step 1 above. Instead, it inserts your chart into the first cell of the table, deleting anything that was in that cell.

For that reason, I feel it is better to avoid using the Chart tool and insert a Microsoft Graph Chart object.

Categories
Outlook 2016

How To Set Automatic Reply for your Vacation in Outlook

You can call it whatever you like, be it vacation reply, out of office message, or whatever you fancy, but below are the quick and easy steps to create it.

Launch Outlook.

  • Click on File | Automatic Replies.
  • Select Send automatic replies.
  • Key in your message.
  • Click OK.

Like I said, easy, peasy!

Categories
Outlook 2016

Delete Or Archive in Outlook?

The Delete and Archive buttons in Outlook are right next to each other. Most people don’t even notice them. And also, unfortunately, most folks have no idea what archive does.

So let me clear that up for you.

DELETE-OR-ARCHIVE

You are welcome!

Categories
Outlook 2016

How To Get Rid of Outdated Auto-Complete Adresses

Auto-Complete addresses are very handy – until they aren’t. Most folks think there is nothing they can do to get rid of these, but there is!

Follow the steps below to learn how:

  1. Launch Outlook.
  2. Open a new message by pressing CTRL + N.

auto-complete

  1. Start keying in a name, and you will see the Auto-Complete list appear.
  2. As you hover over each name you will see an x appear at the right of it.
  3. Simply click the x to rid yourself of that Auto-Complete!
  4. You can actually delete all Auto-Complete suggestions.

Follow these steps to learn how:

  1. Clink File | Options | Mail.
  2. Scroll down to Send Messages and click either Empty-Auto-Complete List or deselect Use Auto-Complete to disable it.
Categories
Word 2016

How To Replace Manual Line Breaks With Paragraghs

As some of you know, I knit for relaxation and I like to donate some of my handmade goods to different charities, so I am always on the lookout for free patterns to use.  There are many available if you look. But it drives me absolutely mad when I find a pattern on the internet and copy and paste it in Word, and it turns out that it was created with manual line breaks instead of paragraphs.  I know I’m a wonk but we all have certain ways of doing things, and mine just happens to be the right way!

Now I just copy and paste and automatically fix this problem every time.

Follow the steps below to learn how:

  1. Highlight your entire document.
  2. Click CTRL + H to open Find and Replace.

 

find-and-replace

  1. On the bottom, click on Special.
  2. In the Find area, select Manual Line Break.

manual-line-break

  1. In the Replace box, use the same process as above and select Paragraph mark.
  2. Click Replace All.

Easy peasy and you now have a document that is easy to maneuver and you can set space before or after, etc.

 

Categories
Word 2016

How To Control Automatic Capitalization In Word

Have you ever been  flying across your keyboard trying to get a document finished, and then you look up and notice that Word has  capitalized words for you that you didn’t intend to be capitalized? Good old Word is trying to help you and usually does this when it thinks you are starting a new sentence. I get it. This can be very aggravating – especially when you are in a hurry. So if this is a problem for you, you can make Word stop being so helpful if you like!

Follow the steps below to learn how:

  1. Press File | Options.
  2. At the left-hand side of the dialog  that appears, click Proofing.
  3. Click AutoCorrect Options to display the AutoCorrect dialog.
  4. Be certain  the AutoCorrect tab is displayed

auto-correct

  1. Delete Capitalize First Letter of Sentences .
  2. Click OK.

Problem solved!

Categories
Excel 2016

How To Create Super Fast Charts in Excel

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?

Categories
Word 2016

How to Unhide Hidden Text in Word

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.

 

 

Categories
Word 2016

How To Create A List In A Word Document

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?

Categories
Outlook 2016

Using Hot Keys in Outlook 365

I don’t know about you, but I am usually as busy as a one armed paper hanger with the itch at the office. That being said, I absolutely avail myself to all the quick shortcuts I can to save time and keystrokes. I really like to use the hot keys in Outlook to save more time.

Some of my favorites are listed below:

outlook-hot-keys

You are very welcome!