Text Box: Contents • Word: Printing Multiple Envelopes • Excel: Using Drop Down Lists for Data Validation • Internet Explorer: Run Time Errors • Excel: Using Custom Views • Outlook: Sending a Distribution List to Another User

 

Word:  Printing Multiple Envelopes

Almost everyone has used Word’s Envelopes feature to print a single envelope when needed.  However, you can easily use this same feature to print multiple envelopes, by creating a document that contains all of the envelopes you want to print.

  1. In a blank Word document, select Tools, Letters and Mailings, Envelopes and Labels from the Word menu.
  2. Select the Envelopes tab and type the address for the first envelope.  Click the “Add to Document” button when you are done.  The address for the first envelope is placed in the document.
  3. From the Word menu, select Insert, Break, and select Next Page under Section Break, then click OK.
  4. Press Ctrl+Home to position your cursor above the break you just placed in the document.

Repeat steps 1-4 for each additional envelope you would like to print, selecting “Change Document” instead of “Add to Document” in Step 2.    When you are done, select File, Print to print the document.  NOTE:  Depending on your printer, the first and last envelope that come out of the printer may be blank. 

 

Excel:  Using a Drop Down List for Data Validation

Last month’s newsletter contained an article about setting data validation rules in Excel.  This article will show you how to create a drop down list from which the user can select the appropriate value to enter into a cell.  For example, in the worksheet below, names entered into the “Assigned To” column must be selected from a drop down list.  Click here for more information

 

 

Text Box: January Tip Sending A Distribution List to Another User There might be times when you want to share a distribution list with another user. You can do this by emailing the distribution list. 1. Open your Contacts and click one time on the distribution list (or contact) that you want to send. To select multiple distribution lists/contacts, hold down the Ctrl key while clicking. 2. Press Ctrl+F 3. The distribution list displays in an email message. 4. Complete and send the email message. All the recipient has to do is open the email message, then drag the distribution list icon to his or her Contacts folder or Contacts icon. Internet Explorer – Run Time Errors

If you frequently receive “Run Time Errors” when using the Internet, you can eliminate them by following these instructions:

Open Internet Explorer and select Tools, Internet Options from the menu.

Click the Advanced Tab.

Scroll to the “Browsing” section of the dialog box and make sure that

            “Disable Script Debugging” is checked, and

            “Display a Notification abut every script error” is unchecked

Click Apply, then click OK.

 

Excel:  Using Custom Views

You can use Excel’s Custom Views feature to create different worksheet view.  For example:  A worksheet may contain sales and commission information,  however, different individuals need to view different calculations. 

  • Some need to view the entire worksheet
  • Some need to see only the total sales for each region
  • Some need to see the only the total commission for each region
  • Some need to see only the commission for each individual

All of this can easily be accomplished by creating Custom Views of the worksheet.  Click here for details.

 

 

Internet Explorer Keystrokes

  • Press ALT+A to open the Favorites menu
  • Press ALT+D  0r F6 to quickly move to the Address Bar
  • Press F4 to display the Address Bar history
  • ALT+ Left Arrow moves you back one page, ALT+Right Arrow moves you forward
  • Press CTRL+D to add the current page to your Favorites
  • Press F5 to refresh the current page
  • Press CTRL+F to open the “Find on this Page” dialog box.

 

 

 

 

 

 

 

.