Tips and Tricks
| A a faster way to look up past purchases
Do you need to look up a purchase, but don’t know the PO number?
Go to Bannerweb and click on the finance section. Click view document and click document number (leave the box blank) This brings you to a search page where you can search for every purchase made in the past month, year, of forever. Submitted by Joanne Hathaway.
| To send a message to someone without other recipients of the message knowing, use the Bcc line in the message. Bcc stands for blind carbon copy. If you add someone's name to the Bcc line, a copy of the message is sent to that person, but his or her name is not visible to other recipients.
| Find yourself switching between Full Screen and Window mode in a program like Windows Media Player? The ESC key can usually be used to turn off Full Screen Mode. The shortcut Alt + Enter also will toggle Full Screen mode on and off.
| If you want to select multiple files that are together, click the first file, then hold Shift, and click the last file. All files in between will be selected as well.
If you want to select multiple files that are spread out in one folder, hold Ctrl as you single click on each file.
| Using Windows, you can put your most often used programs in the top of the start menu so they are easily accessible. Open the start menu and find the program you'd like to access, right click that link and choose Pin To Start Menu.
If you want to remove a pinned program, right click on it and choose Remove from Start Menu
| In Excel, pressing Ctrl and then the ' key will copy the contents of the cell above the current cell.
| A spectacular yet underused feature is Word's ability to display two different parts of a document at the same time. To do this, you can either select the Split option from the Window menu to display a dividing line in the current window.
| In Excel you can press Alt-Enter to start a new line within a cell.
| Do you want to keep the column headings visible on each page when printing Excel?
1. Go to the page layout tab and select Print Titles.
2. Under rows to repeat at top Select the row containing your column headings.
| Introducing the Mini-Toolbar.
Did you know that you can use the mini-toolbar in Microsoft Word, Excel, PowerPoint, and Access 2007 and newer to quickly format text? Select the text you want to change, and the mini-toolbar appears. When you've finished, the mini-toolbar goes away.
| If you often copy and paste by going to the menu, and clicking through Edit - Copy, Edit - Paste then you'll find it much faster to use keyboard shortcuts
To Copy, highlight what you'd like to copy, hold the Ctrl key, and press c. Release both buttons.
To Paste, put the cursor where you would like to paste, hold the Ctrl key, and press v. Release both buttons.
| In Microsoft Word, you can hit Ctrl+s to save your work at any time.
| You've probably noticed that Word completes certain phrases, such as "Best Wishes," before you've finished typing. You can customize this list so that Word completes only the phrases you define. Select AutoCorrect Options from the Tools menu, then go to the AutoText tab. Delete any items you don't want to keep, then add names and phrases that you type often, such as your name, company, or address
| Keyboard shortcuts in Word.
To move to the previous or next word, press Ctrl+Left Arrow or Ctrl+Right Arrow. To go to the beginning or end of a document, press Ctrl+Home or Ctrl+End.
| The AutoCorrect feature in Office can automatically place symbols in your documents. Here are some of our favorites.
(c) will do this: ©
(r) will do this: ®
(tm) will do this: TM
| Creating an Excel Chart in a Few Easy Steps
1. Using your keyboard select the data you want to plot.
2. Press F11 and Excel will automatically create a chart for you.
| In Microsoft Word, you can easily change the font and presentation of your text by highlighting the text you want, right clicking, and then selecting "Font."
| Change the case of text in Microsoft Word
1. Select the text you want to change and press SHIFT+F3.
2. Each time you click F3 the text case switches between Title Case, UPPERCASE, and lowercase.
| Format on the fly with keyboard shortcuts.
Select text and hit Ctrl-B to bold, Ctrl-U to underline, Ctrl-I to italicise, Ctrl-[ and Ctrl-] to change font size, or Ctrl-Shift-A to toggle between CAPS and lowercase.
| It is possible to take a picture of your computer screen and insert that picture into Word, PowerPoint, Excel or any other program that accepts image files. *be careful what you capture and email to people. Email is not a secure way to transfer confidential information.*
Hitting the print Screen button will take a picture of your entire desktop
Hitting ALT Print Screen captures just the active window you are work in.
Try hitting print screen, opening Word and hit the past button.
Check out the help sheet on capturing
Shift-Command-3 Capture the screen to a file
Shift-Control-Command-3 Capture the screen to the Clipboard
Shift-Command-4 Capture a selection to a file
Shift-Control-Command-4 Capture a selection to the Clipboard
| Windows 7 or 8, To open multiple sessions of a program, like Word, hold down the shift key and click the program on your task bar.
| Can't find a file? Windows
(Windows – F) Press and hold the Windows key and hit f on the keyboard to bring up the search box. Here you can search by title or words contained in the body of a document. The Windows key located by the left alt key.
Option-Command-F Press and hold all three buttons until the search box comes up to navigate to the search field in an already-open Spotlight window. Here you can search by title or words contained in the body of a document. The Option and Command buttons are located to the left of the space bar.