Proactive Computing | Optimizing IT for usability, performance and reliability since 1997

Category: #Office365 (Page 1 of 8)

Auto Added by WPeMatico

Why Excel Looks The Way it Does

368d44e3.png
The spreadsheet you are probably most familiar with is Microsoft Excel. But have you ever wondered why Excel looks and acts the way that it does? Why does Excel arrange data in a grid of cells? Why are columns identified by letters, and rows by numbers? The answer, like most things in IT, is because of compatibility.

Read This Article on CloudSavvy IT ›

Source: https://www.cloudsavvyit.com/8270/why-excel-looks-the-way-it-does/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Jim Hall

How to Insert Outlook Contact Information in Microsoft Word

office_word_lede.png
There are a number of ways to insert contact information into a Word document. Perhaps the easiest is just adding an Address Book button to the Quick Access Toolbar so that you can add contacts on-the-fly and at the touch of a button in any Microsoft Office application.

Read This Article on How-To Geek ›

Source: https://www.howtogeek.com/695161/how-to-insert-outlook-contact-information-in-microsoft-word/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Bryan Clark

How to Use Linked Text to Update Multiple Word Documents

office_word_lede.png
Microsoft Word makes it easy to add the same text to multiple documents. This is especially handy for text with special formatting, the kind of text that often breaks when pasting it into a new document. The time you find yourself changing the same details in a dozen documents, try this instead.

Read This Article on How-To Geek ›

Source: https://www.howtogeek.com/695409/how-to-use-linked-text-to-update-multiple-word-documents/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Bryan Clark

How to Change Kerning in Microsoft Word

stock-lede-microsoft-office-word-1.png
Kerning refers to the adjustment of space between two characters, generally used to improve the visual aesthetics of text. You can change the kerning in Microsoft Word in just a few steps. Here’s how.

Read This Article on How-To Geek ›

Source: https://www.howtogeek.com/695173/how-to-change-kerning-in-microsoft-word/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Marshall Gunnell

How to Export and Import Outlook’s Safe and Blocked Senders

stock-lede-microsoft-office-outlook-1.pn
Microsoft Outlook’s Junk Email functionality works best when you train it by adding senders to the Safe Senders and Blocked Senders lists. Here’s how to export those lists and reimport them to a new machine or account.

Read This Article on How-To Geek ›

Source: https://www.howtogeek.com/699836/how-to-export-and-import-outlooks-safe-and-blocked-senders/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Rob Woodgate

What’s New in Outlook 365 for Mac’s Fall 2020 Update

microsoft-office-logo-new.jpg
Microsoft Outlook 365 received a nice update for Mac in the fall of 2020. Along with an enhanced look came new and improved features. With everything from a customizable toolbar and better search to the ability to snooze emails, let’s take a look at all that’s new in Outlook 365 for Mac.

Read This Article on How-To Geek ›

Source: https://www.howtogeek.com/700319/what%E2%80%99s-new-in-outlook-365-for-macs-fall-2020-update/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Sandy Writtenhouse

How to Calculate the Sum of Cells in Excel

stock-lede-microsoft-office_excel-1.png
Microsoft Excel may be known for complex calculations and formulas, but it’s no slouch at simple arithmetic. There are a number of ways to find solutions to simple math problems, like finding the sum of numbers in multiple cells.

Read This Article on How-To Geek ›

Source: https://www.howtogeek.com/696837/how-to-calculate-the-sum-of-cells-in-excel/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Bryan Clark

How to Insert a Hyperlink in Microsoft Word

This wikiHow teaches you how to add clickable links to your Microsoft Word documents. You can make any text or image in your document a hyperlink that, when clicked, brings the reader to another place in the document, an external website, a different file, and even a pre-addressed email message. The links you create will remain active even if you convert the Word document to the PDF format.

[Edit]Steps

[Edit]Linking to Another Document or Website

  1. Select the text or image that you want to turn into a link. You can turn any text or image in your document into a link. Highlight the text or click the image that you want to convert into a hyperlink.
    Insert a Hyperlink in Microsoft Word Step 1 Version 6.jpg
    • To insert an image into your document, click the Insert tab and select “Pictures.” You’ll be able to browse your computer for an image file to add. You can also insert clipart to use as a link.
  2. Press (Mac) or (PC). This opens the Insert Hyperlink window. You can also get to this menu by clicking the Insert tab and then clicking the Link button in the toolbar.
    Insert a Hyperlink in Microsoft Word Step 2 Version 6.jpg
  3. Select from the left panel. More options will appear in the right panel.
    Insert a Hyperlink in Microsoft Word Step 3 Version 6.jpg
  4. Select a file or enter a web address.
    Insert a Hyperlink in Microsoft Word Step 4 Version 6.jpg
    • To link to a website or a file that’s accessible on the web, type or paste the full address (including the “https://” at the beginning) into the “Address” field near the bottom of the window.
    • To link to a file on your computer or local network, select that file in the center panel. If it’s in the current folder, click Current folder to open its contents. If you opened it recently, click Recent Files to browse those. You can also use the menus at the top to navigate to the correct folder and select the file.
    • To create a new blank document instead of opening a certain file, click Create a new document in the left menu, then choose a location for the document.
  5. Set a ScreenTip (optional). You can change the text that appears when the user rests the cursor over the link by clicking the ScreenTip button at the top-right corner and specifying your text. If you don’t change it, the screen tip will also display the website address or file path.
    Insert a Hyperlink in Microsoft Word Step 5 Version 6.jpg
  6. Click to save your link. You can now test your link by holding down the Command (Mac) or Ctrl (PC) button on the keyboard while clicking it.
    Insert a Hyperlink in Microsoft Word Step 6 Version 6.jpg

[Edit]Linking to a Blank Email Message

  1. Select the text or click the image you want to turn into an email link. You can use any text or image in your document. When you’re finished with this method, clicking the selected text or image will bring up a new email message to the address of your choice.
    Insert a Hyperlink in Microsoft Word Step 7 Version 6.jpg
  2. Press (Mac) or (PC). This opens the Insert Hyperlink window. You can also get to this menu by clicking the Insert tab and then clicking the Link button in the toolbar.
    Insert a Hyperlink in Microsoft Word Step 8 Version 6.jpg
  3. Click in the left panel. This allows you to set up the blank message.
    Insert a Hyperlink in Microsoft Word Step 9 Version 6.jpg
  4. Enter the e-mail address and subject. This will be the address that the reader will be sending the email to. What you enter into the “Subject” field will be automatically filled in for the reader, but they will be able to change it if they want.
    Insert a Hyperlink in Microsoft Word Step 10 Version 6.jpg
    • If you use Outlook, you’ll see recently-used email addresses in the field at the bottom of the window. Feel free to select one of those.
    • Some mail apps, especially web-based email apps, may not recognize the subject line.
  5. Set a ScreenTip (optional). You can change the text that appears when the user rests the cursor over the link by clicking the ScreenTip button at the top-right corner and specifying your text. If you don’t change it, the screen tip will show the email address.
    Insert a Hyperlink in Microsoft Word Step 11 Version 6.jpg
  6. Click to save your link. You can now test your link by holding down the Command (Mac) or Ctrl (PC) button on the keyboard while clicking it. Your default email app will open to a new message containing addressed to the address you entered previously.
    Insert a Hyperlink in Microsoft Word Step 12 Version 6.jpg

[Edit]Linking to a Place in the Same Document

  1. Place your cursor at the location you want to link to. You can use the Bookmark tool to create links to specific spots in your document. This is great for tables of contents, glossaries, and citations. You can highlight a portion of text, select an image, or just place your cursor in the spot you want.
    Insert a Hyperlink in Microsoft Word Step 13 Version 6.jpg
  2. Click the tab. It’s in the menu bar at the top of Word.
    Insert a Hyperlink in Microsoft Word Step 14 Version 6.jpg
  3. Click the button. It’s in the toolbar at the top of Word in the “Links” section.
    Insert a Hyperlink in Microsoft Word Step 15 Version 6.jpg
  4. Enter a name for the bookmark. Make sure the name is descriptive enough that you’ll be able to recognize it. This is especially important if you are using a lot of bookmarks or more than one person is editing the document.
    Insert a Hyperlink in Microsoft Word Step 16 Version 6.jpg
    • Bookmark names have to start with letters but can also contain numbers. You can’t use spaces, but you can use underscores instead (e.g. “Chapter_1”).
  5. Click to insert the bookmark. Bookmarks will appear on the page surrounded by brackets. You won’t see the bookmark on the page if you’re using a modern version of Word, but in earlier versions, it may be surrounded by brackets.
    Insert a Hyperlink in Microsoft Word Step 17 Version 6.jpg
    • If you want to see brackets around the bookmark so you don’t forget where you placed it, click the File menu, select Options, and click Advanced in the left panel. Then, scroll down the right panel and check the box next to “Show bookmarks” under the “Show document content” header.
  6. Select the text or image you want to create the link from. Highlight the text or click the image that you want to turn into a link to your bookmark.
    Insert a Hyperlink in Microsoft Word Step 18 Version 6.jpg
  7. Press (Mac) or (PC). This opens the Insert Hyperlink window. You can also get to this menu by clicking the Insert tab and then clicking the Link button in the toolbar.
    Insert a Hyperlink in Microsoft Word Step 19 Version 6.jpg
  8. Click in the left panel. This displays a navigation tree with your heading styles and bookmarks.
    Insert a Hyperlink in Microsoft Word Step 20 Version 6.jpg
  9. Select the bookmark you want to link to. Expand the “Bookmarks” tree if it isn’t already and select the bookmark you created. You can also select from heading styles you’ve applied throughout the document.
    Insert a Hyperlink in Microsoft Word Step 21 Version 2.jpg
  10. Set a ScreenTip (optional). To change the text that appears when the user rests the cursor over the link, click the Screen Tip button at the top-right corner. If you don’t change the text, the screen tip will display the website address or file path.
    Insert a Hyperlink in Microsoft Word Step 22 Version 2.jpg
  11. Click to save your link. You can now test your link by holding down the Command (Mac) or Ctrl (PC) button on the keyboard while clicking it. This will recenter the view to the line on which you placed the bookmark.
    Insert a Hyperlink in Microsoft Word Step 23 Version 2.jpg

[Edit]Video

[Edit]Tips

  • If you type a URL into a document (e.g., https://www.wikihow.com), Word will automatically make that text a clickable link.
  • You can remove a hyperlink by right-clicking it and selecting Remove Hyperlink.[1]

[Edit]Related wikiHows

[Edit]References

[Edit]Quick Summary

Source: https://www.wikihow.com/Insert-a-Hyperlink-in-Microsoft-Word
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By:

How to Use Exponents in Excel

stock-lede-microsoft-office_excel-1.png
Exponents are simply repeated multiplications. For example, four to the third power (4³) isn’t 4 x 3, it’s 4 x 4 x 4, which equals a total of 64. If that sounds complicated, fear not; Excel can do the heavy lifting for you!

Read This Article on How-To Geek ›

Source: https://www.howtogeek.com/697481/how-to-use-exponents-in-excel/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Bryan Clark

« Older posts