PC Support Newsletter

 

Systems Development

The University of North Carolina at Charlotte

November 2004

 

 


Text Box: Contents

•	Outlook – Assigning Categories to Email Flags
•	Word – Eliminating the Paste Options Icon
•	Word:  Quick and Easy Bullets
•	Excel Tips
•	Outlook:  Must open HTML Message before Printing
•	Word:  Spell Check Ignores Uppercase Words

While it is not possible to assign categories to the Flags that Outlook provides for flagging email, you can get around this limitation by creating a “Flag” toolbar to contain all of the flags you use and a name for each of them.   For example,  the toolbar could consist of the Red Flag (Important), the Blue Flag (Banner), the Yellow Flag (Personal), the Green Flag (Research) and the Orange Flag (Review).  The Flag Complete icon can also be included.  You can then tell at a glance what each flag indicates and quickly flag email by clicking the appropriate icon.   Click here for details

 

 
Outlook – Assigning Categories to Email Flags

 

 

 

 

 

 

 

Text Box: November Quick Tip

When a Word or Excel file is open, you may want to view the full path information for the file.  A simple way to do that is to select View, Toolbars, Web from the menu.  The full path and title of an open file will always display in the Address portion of the toolbar

When you paste text in a document, Word displays a little “Paste Options” icon.  Some people find this icon helpful, some do not.  If you would like to eliminate the Paste Options icon from displaying whenever you paste text:

From the Word menu, select Tools, Options.

Select the Edit tab

Clear the “Show Paste Options Buttons” check box

Click OK.

 

 
Word – Eliminating the Paste Options Icon

 

 

 

 

 

 

 

Word:  Quick and Easy Bullets

To begin a bulleted list in Word, type two dashes, a space, then begin typing the first line of your bulleted list. Press Enter to continue to add bulleted items.  NOTE:  (If this does not work, select Tools, Autocorrect Options and select the “AutoFormat as You Type” tab.  Click on “Automatic bulleted list” to enable this option. 

Notes:

·         If a bulleted item will contain more than 1 line of text, press Shift+Enter after each line.

·         To stop the bulleted list and return to normal text, press Enter twice.

 

 

 
 

 

 

 

 

 

 

 

 

 

 

 


Excel Tips

 

  • To place a checkmark in a worksheet, format the cell with Marlett font and type the letter “a” (without the quotation marks).
  • Excel recognizes an equal sign as the beginning of a formula.  However, to type an equal sign that you do not want to considered as a formula, type an apostrophe in front of the equal sign.
  • If you have more than one worksheet that must contain the same data (ie column headings), hold down the CTRL key and click each worksheet tab to select the sheet.  When all of the sheets have been selected, click in a cell on sheet 1 and begin to type your data. The data will be entered into all selected worksheet.  When you are done, click any worksheet tab to “ungroup” the worksheets.
  • To toggle between viewing formulas and values, press CTRL + `(single left quotation mark, located on the same key as the tilde ~ symbol).
  • To quickly format a cell, click in the cell and press CTRL +1 to open the Format Cell dialog box.

 

Outlook:  Please Open this HTML message to print it

When you right click a message in your Inbox and select Print from the shortcut menu, you may receive this message:  “Please open this HTML message to print it.”   Microsoft has acknowledged that this is an issue with email messages that are formatted with HTML.  Since the format of an email message is determined by the sender, there is no way to get around the message other than opening the email prior to printing it.   One more note:  In  Outlook 2003, this behavior does not seem to occur if the Reading Pane is visible (View, Reading Pane).

 

Word:  Spell Check Ignores Words in Uppercase

By default, a Word spelling check ignores words that are all uppercase.  To change this option and have word spell check upper case words, select Tools, Options, and on the Spelling and Grammar tab, de-select “Ignore Words in UPPERCASE”

 

 

Newsletter Archives at PC Support Newsletters

Address questions or comments about this newsletter to Judy Freed, Systems Development