pc support newsletter Systems Development The University of North Carolina at Charlotte September 2005

Contents ·         Accessing Banner from the Application Launcher ·         Email: Quarantine Notices ·         Excel: Scaling a Worksheet for Printing ·         file:///H:/My%20Documents/Newsletters/October2005/October2005.htm#Calendar ·         Word:  Fun Fonts and Page Borders ·         file:///H:/My%20Documents/Newsletters/October2005/October2005.htm#Task ·         Excel: Introduction to Autofilter

 

Internet Explorer: Run Time Errors

If you frequently encounter “Run Time” errors when using Internet Explorer:  Open Internet Explorer and from the menu, select Tools, Internet Options.  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.

 

More Internet Explorer Tips

• You can sort your Favorites in alphabetical order:  Select View, Favorites from tne menu.  Once the Favorites are displayed, right click anywhere in the list and select “Sort by Name.”
•             Send mail from Internet Explorer:  In the address bar, type:  mail to: followed by the full email address of the intended recipeint (ie mailto:jtfreed@email.uncc.edu).  A blank email message form will display.
• If you want to see web sites related to the one you are looking at, select Tools, Show Related Links from the IE menu.  A list of similar sites will display on the left side of your screen.
• If, while browsing, you would like to click on a link but save your current location, hold down the Shift key while clicking the link.  It will open a new window to display the second link.
• Pressing the BACKSPACE key is the same as clicking the BACK button on the IE toolbar.  Pressing Enter is the same as clicking the NEXT button.
• Click in the Address Bar, type .. (2 periods) and press Enter to quickly return to your Home Page.
• Every now and then a web site asks if you want to make it your home page and you accidentally respond Yes.  If that happens, you can reset your home page this way: 

1.        Go to http://www.uncc.edu/

2.       From the Internet Explorer menu, select Tools, Internet Options and click the General tab. 

3.       In the Home  Page section of the dialog box, click Use Current.

4.       Click Apply, then click OK

• Want to see more of the web page you are viewing?  Select View, Full Screen from the IE menu.  To return to regular viewing, click the “Full Screen” icon on the toolbar.

 

Excel:  Use Conditional Formatting to Alternate Row Shading (The Greenbar Look)

To make your worksheets more visually appealing, you might want to apply shading to alternate rows – (the greenbar look).   You can easily accomplish this using Conditional Formatting.  Click here for more information.

 

Header Rows when sorting in Excel

When you need to sort an Excel worksheet, make sure that Excel recognizes your data range correctly by clicking in a cell and pressing CTRL+SHIFT+8.  Excel will highlight the data range (the cells that will be sorted).  Look at the header row (if your worksheet has one) – it should be the first row of the selected data. Note the following:

 

Are there blank cells in the first row? 

Is the first row formatted exactly like all of the other rows?

 

If either of these conditions are true, then Excel will probably not recognize your first row as a  header row and your sort may not give you the desired results.  Make sure the header row has a column heading for every column in the data range, and go ahead and bold the header row.

 

Zoom In for a Closeup

In Word or Excel, holding down the CTRL key and rolling the mose wheel will Zoom In or Zoom out of your document

 

 

 

 

Questions or comments….Contact  jtfreed@email.uncc.edu