|
pc support newsletter Systems
Development The
University of North Carolina at Charlotte March 2006 |
|
Contents
|
Excel: Extracting the year from a date field
The worksheet below contains dates in column A. The user needs to have the only the year display in column B.
March Quick Tip Outlook: Finding Related Email Messages Right click on an
email message and select “Find All…Related Messages”. Outlook will display a list of all emails
with the same subject line.
- In cell B2, type the formula: =Year(A2)
- Press Enter
- Use Autofill to copy the formula to the rest of the cells.
Excel:
Adding Pop Up Notes to Cells
While Excel’s Data Validation feature is most commonly used to check data that is entered in a cell, it can also be used to place “Pop Up” notes that will display when a user selects a cell - this might be useful if you want to add some additional information or explanation to a cell entry. Click here for more information.
UNC
Charlotte Web Pages: People Finder Updates
The following changes have been made to the People Finder for Employee/Staff:
· Preferred First Names: The search function now includes “Preferred First Name” field.
·
vCARD: The small icon found to the right of the
person’s name is an electronic business card which can be added to your Outlook
contacts. Double click the vCard icon to
open it and then select Save and Close when the contact information displays.
Misc. Word
Tips
- Did you know that Word can
remember the last place you were working in a document? Open the document
then immediately press Shift +
F5
- To quickly change line spacing in a document: Select the desired text, then press CTRL+1 for single spacing or CTRL+2 for double spacing.
- Aligning Numbered Lists on the
Period: When you use the
Bullets and Numbering feature to automatically number lists, if the list
has more than 9 items, your numbers will not align on the period. To
correct this, select the list, right click and select Bullets and
Numbering from the shortcut menu that displays. In the Bullets and
Numbering dialog box, select the Numbers tab, then select Customize.
In the Number Position box, select Right.
- Resuming Automatic Numbering in Word: Sometimes when typing a
numbered list in Word, you need to include a non-numbered paragraph then
resume the numbered list. This is easy done in Word XP. After
typing the non-numbered paragraph, press Enter, then click the Numbering
button on the toolbar. When Word displays the Smart Tag, click on it
and select Continue Numbering
- Moving Paragraphs in Word: To quickly move an entire paragraph in Word, click anywhere in the paragraph, then, while holding down the ALT+SHIFT key, press either the Up or Down arrow key. You can also use the mouse to select more than one paragraph
Word: Linking a Word document to an Excel Worksheet
You can use the
Hyperlink feature to link documents from various Microsoft applications. For example:
You can place a link in a Word document that references an Excel
worksheet. Holding the CTRL key and
clicking on the link will open the worksheet.
Click
here for more information
Correcting
Run Time Errors in Internet Explorer
To eliminate “run time” errors in Internet Explorer, select Tools, Internet Options from the menu. Click the Advanced tab. In the Browsing section of the dialog box, make sure that Disable Script Debugging is checked, and that Display a notification about every script error is unchecked. Click Apply, then click OK.
Questions or comments? Contact jtfreed@email.uncc.edu