Systems Development The March 2005 PC
Support Newsletter
Saving Portions of
Email to a Note
There may be times when you need to save a portion
of an email for future reference – for example, a confirmation number, login
information, a web site to visit for assistance with an account. You can, of course, write the information
down, but it is easier to just select the portion of the email you need to
save, and drag it to the Notes icon on the Outlook bar. The selected text is then saved as an Outlook
note.
Masking Social
Security Numbers in an Excel Worksheet
Many of the Excel worksheets that we use contain social security numbers and there may be times when you want to “mask” a portion of the number so that only the last 4 digits of the social security number display. Excel offers two ways that you can do this. The first method masks the first 5 digits of the social security number with asterisks (***-**-1111); the second method displays only the last 4 digits of the social security number. Click here for details
Pasting Excel Worksheets as Pictures
- To paste an image of an Excel worksheet (or a portion of the worksheet) into a file, such as a Word document , Powerpoint presentation or email message:
- Select the cells you want to copy
- Holding down the Shift key, select Edit, Copy Picture.
- Make sure “As Shown on Screen” and “Picture” are selected.
- Click OK.
Go to the document or email message in
which you want to paste the picture and select Edit, Paste from the
menu. Note that cell gridlines
display in the picture if they are visible in the worksheet.
Bigger Text in
Internet Explorer
If the text the web page you are viewing is too small, try holding down the CTRL key and move the mouse wheel backwards to increase the size of the text, or forwards to decrease it. NOTE: (This is not a consistent feature. It works on some web pages, on others it does not. In some cases, increase/decrease is carried from page to page, in some cases it is not. But if you have trouble reading the text on a web page, it’s worth a try).
Launching Internet Shortcuts in Separate Windows:
Problem: The user is working in Banner. She also has a shortcut to EPrint on her desktop. When she clicks on the EPrint shortcut, Banner closes and Eprint opens. She would like to be able to click on the EPrint shortcut and have EPrint open in a separate window.
Solution: From the Internet Explore menu, select Tools, Internet Options. Click the Advanced Tab. In the Browsing section of the dialog box, deselect “Reuse Windows for Launching Shortcuts”, then click Apply and OK. Clicking the EPrint shortcut will now open EPrint (or any other Internet Shortcut) in a separate window
Quickly
Create Horizontal Lines in Word
Editing in the
Formula Bar – A Matter of Preference!
To activate the formula bar using the keyboard, click in the cell that contains the formula you wish to edit and press F2. By default, Excel will activate the cell that contains the formula, allowing you to directly edit the formula in the cell as in the example below.
If you would rather F2 take you directly to the formula bar, select Tools, Options, and on the Edit tab, deselect “Edit directly in cell” and click OK. This changes the behavior of the F2 key, so that instead of activating the cell, Excel activates the formula bar as in the example below – the cursor is positioned in the formula bar, not directly in the cell.
Questions or comments? Please email jftreed@email.uncc.edu