Forestry Computing Helpdesk
Helpdesk Home Page COF Homepage Report a Problem to Helpdesk Computer Facilities Information Hardware and Software Tutorials Search Engines






Office 2000 Articles and Tips from Microsoft

Keyboard Shortcuts - An Excel Spreadsheet

Add Clip Art
Comments, E-Post-its
Deleting and Renaming Files While Opening or Saving
Drawing Straight Lines
Edit Your Custom Dictionary
Format Painter
Line Breaks Without Bullets
No More Smart Menus
Recently Used File List
Try the [Shift] Key
Toolbars


Add Clip Art
You can add any picture file (GIF, JPG, others) to the Clip Gallery. The Clip Gallery serves all Office 97 applications. From within an Office 97 application choose Insert, Picture, ClipArt. When the Clip Gallery opens, click Import Clips. In the Add Clip Art To Clip Gallery dialog box, locate your new GIF (or other picture) file and double-click to import it and close the dialog box. The Clip Properties dialog box opens now. Click the category in which you want your new picture to appear, then click OK to close the dialog box and save your selections.


Comments, E-Post-its
Editing a document by committee? Consider using comments in Word or Excel to insert electronic yellow sticky notes in your document. In a collaborative document, you can place electronic yellow notes by first selecting the Word text or Excel cell you're critiquing. Open the Insert menu's Comment option and type your comment in the window. When you're finished, click Close, and you won't be able to miss the highlighted text.
  • In Excel, cells with comments have a red triangle in the upper-righthand corner. Comments will be displayed any time you position your mouse over a cell that has an attached comment.
  • In Word, text with an associated comment is highlighted, appropriately enough, in yellow.
If your document comes back with comments, first open the Reviewing toolbar (right-click any toolbar and select Reviewing). The Reviewing toolbar is most useful for the Next and Previous Comment icons. To review comments, click the Next Comment icon. Hold your cursor over the highlighted text and a box will pop up with the comment.


Deleting and Renaming Files While Opening or Saving
Did you know that you can delete and rename files any time you're in the midst of a File | Open or File | Save dialog box? When the open or save dialogs present you with a list of files that you're browsing in the current folder, you can right-click a file and choose Delete or Rename. Alternatively, to delete, you could just click the file once to select it and then tap the Delete key. To rename, you could click the file once to select it, then click the filename to position your cursor for editing the name.


Drawing Straight Lines
If you use the drawing toolbar to draw lines you may have had the experience of being frustrated by the very precise mouse movements required to draw a straight line. You can draw straight vertical and horizontal lines by holding down [Shift] while you draw the line. The same technique works for lines at a 45-degree angle.
  1. Click the Line button in the Drawing toolbar and press [Shift].
  2. Keep holding [Shift] and now, draw an approximately straight line at a 45-degree angle or vertically or horizontally.
  3. When you let go of the [Shift] key you'll find that you have actually managed to easily draw a perfectly straight line.


Edit Your Custom Dictionary
When you do a spell check in any Microsoft Office application, a misspelled word presents a dialog box with options including Change, Ignore, and Add. If you add the word to your custom dictionary, the same custom dictionary is used in all Office applications. Did you know that you can view and edit the words in your custom dictionary? Instructions below tell how to edit the file from Word or Outlook but in either case you're working with the same file.
In Word: Tools | Options | Spelling and Grammar tab
Click Dictionaries | then click Edit for the already selected CUSTOM.DIC file
In Outlook: Tools | Options | Spelling tab | Click Edit


Format Painter
The Format Painter in Word and Excel can be very useful. You can use the Format Painter -- that little paintbrush on the Standard toolbar -- to copy formatting from cells, words, or an entire paragraph, and "brush" that formatting on to other cells, words, or paragraphs. This feature is great when you've spent considerable time fiddling with fonts, spacing, sizing, and so on, and now have everything just the way you want it. To copy formatting, follow these steps:
  1. Select the words or cells containing the formatting you want to copy. If you want to copy paragraph formatting (such as alignment, numbering, indents, and so on), select the entire paragraph.
  2. Click the Format Painter. (Double-click the Format Painter if you plan to copy the selected formatting to more than one text item cell or paragraph.) When you click Format Painter, a little paintbrush appears beside the mouse pointer.
  3. Using the paintbrush pointer, select the target text. You can press [Esc] at any time to turn off Format Painter and restore the regular mouse pointer.


Line Breaks Without Bullets
PowerPoint, Word, FrontPage -- In the midst of typing in a bulleted or numbered list, sometimes you want to move to a new line without generating a new bullet or number. Use Shift-Enter and you'll get a new line within the same bullet.


No More Smart Menus
Want to see all the menu options instead of the Office 2000 menus being "smart" and showing you only the options you've recently used? Make the following change in ANY Office application:
  1. Right-click in the gray area to the right of the File - Edit - View - ... - Help menu
  2. Choose Customize
  3. Go to the Options tab of the Customize dialog
  4. Uncheck "Menus show recently used commands first"
  5. Close
Your menus in ALL Office applications are no longer smart!


Recently Used File List
Ever wish that the recently used file list at the bottom of the File menu would have a little longer memory? You can change this setting, making the change in each Office application, by going to Tools | Options | General tab | and adjusting the Recently Used File List option to the number of files you would like displayed in that application.


Try the [Shift] Key
Hold down the [Shift] key before clicking on the File menu. Notice that you now get options to Close All and Save All currently open files/windows in the current application (like Word or Excel).


Toolbars
A shortcut to View | Toolbars is to right-click in a toolbar or menu bar area.



Select a Frequently Visited Page...
Search the Helpdesk Web pages...
InfoSeek Help.
Helpdesk Home Page COF Homepage Report a Problem to Helpdesk Computer Facilities Information Hardware and Software Tutorials Search Engines


the current number of problems in the database is:
Warning: readfile(http://webdata.forestry.oregonstate.edu/helpdesk/problemcount.php): failed to open stream: HTTP request failed! HTTP/1.1 401 Access Denied in /www/template/helpdesk/footer.php on line 69

disclaimer you may direct comments to the Forestry helpdesk