Category: Microsoft Office

Categories
Office 365

How to Create Hyperlink To File on Your Computer

In a previous post I told you how to create a hyperlink to a Web page. Today I will show you how to create a hyperlink to a file that resides on your computer or alternatively, to a new file that you would like to create on your computer.

Follow the steps below to learn how:

  • Select the text or image that you would like to display as a hyperlink.
  • Press CTRL + K.
  • Under Link to, select one of the following:
  • To link to an existing file, under Link to, click Existing File or Web Page.
  • In the Look in or Current Folder list, find your file.

insert-link

  • If you would like to create a new, blank file, and link to it, click Create New Document under Link to.
  • Key in a name for your new file and use the location shown under Full path or navigate to a different save location by clicking Change.
  • Now, you can select whether to Edit the new document later or open and Edit the new document now.

There is more information coming in a future post.  Keep an eye out for it!

Categories
Office 365

How To Add & Remove Hyperlinks in Outlook 365

outlook

First of all, this information does not pertain only to Outlook.  It also is relevant for Word, Excel and PowerPoint.

Ok, now that is out of the way let’s move on.  As you know, you can  create links to new files or on ones that have been on your computer for ages. These links can be added to locations in documents, and to email addresses. You can also edit them as you would anything else.

The quickest way to create a rather basic hyperlink in your document is to press Enter or your Space bar once you have keyed in the address of an existing webpage (i.e. www.carolscorneroffice.com).  Office will automatically convert the address to  a link for you.

If you wish to create a hyperlink with in your document, follow the steps below:

  • Select the text or image that you would like to display as a hyperlink.
  • Press CTRL + K (you can also, if you prefer, right-click on your text or picture and click Link on the shortcut menu).
  • Now, in the Insert Hyperlink box that appears, key in or paste your link in the Address area.
  • If you do not see the Address box, be certain the Existing File or Web Page is selected under Link to.
  • You can also, if you like,  key in your own text to display for your link in the Text to display area.
  • Should you not know the web address for your hyperlink, simply click the Browse the Web icon, navigate to the URL on the Internet, copy and paste it. browse-the-webThat is basically how it is done!
Categories
Word 365

How To Delete Captions In Word Documents

Word

You will not believe how simply easy this is!

If you would like to delete a caption in your Word document, all you need do is select the caption and click your Delete key! If there are more captions in your document when you are finished  removing the ones you no longer want, you can then update them.

Follow the steps below to learn how:

  • Press CTRL + A which will select all text in your document, and then press F9 to updatel. Now, all your caption numbers are in order after you have removed the ones you no longer want!

Told you it was super easy!

Categories
Microsoft Word

Quickly And Easily Delete All Tab Stops in A Document

Word

If you are looking for a quick way to delete all tab stops in your document, this post is for you.  It will save you lots of time and you all know I love that!

While there is no keyboard shortcut to remove tab stops — it is very easy to use the Tabs dialog box to resolve this issue. You can use your  keyboard to open the  Tabs dialog box and make selections within it, which  technically does not count as a keyboard shortcut.

Follow the steps below to learn how:

    1. Press Ctrl+A to select your entire current document.
    2. Display the Home tab of your Ribbon.
    3. At the bottom-right of the Paragraph group, click the small icon to display the dialog box.
    4. Click Tabs at the bottom-left of the dialog box to display the dialog box.
    5. Click Clear All.
    6. Click OK.

Saves you mucho time!

Categories
Microsoft Office

How To Use Building Blocks To Create A Publication

You can speed up your document creation in Publisher using Building Blocks – these are content blocks that you can use over and over. See the different types of Blocks below:

  • Calendars – Stories, sidebars and headings
  • Page Parts – Stories, sidebars and headings
  • Borders and Accents – Reusable graphic elements
  • Advertisements – Coupons and other advertising content
  • Business Information – Contacts and other information about your company

You can also find four galleries of Building Blocks in the Building Blocks group on your Ribbon. The fifth gallery, Business Information, can be found in the Text group.

Categories
Word 2016

How To Convert Tables To Charts In Word

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

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?

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

outlook

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

Word

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.