MS Office Tips & Shortcuts
  1. To Double Underline in Excel: Select cells to double underline and hold down the Shift key and click on the Underline button on the Tool Bar.
  2. To Move an entire paragraph up or down in Word: Place the cursor anywhere in the paragraph and hold down the Alt key and the Shift key and press the up or down arrow.
  3. To Copy a PowerPoint Slide into another Application: In PowerPoint, click on View, Click on Notes Page.  Right click on the slide, click on Copy.  Go to where you want to copy it and Right click Paste.
  4. In Excel to Drag and Drop the contents of selected cells to another sheet: Hold down the Alt key while dragging with the white arrow pointer and point to the sheet tab to move to, then point to the cell tot move to and release the mouse button then the Alt key. To copy, hold down the Alt + Ctrl key while dragging.
  5. To Print what is displayed on your Screen: Press the Prnt Scrn button on your keyboard (this is above the Insert key on most keyboards),  then open Word or WordPad and press Ctrl+V to paste the image you just copied to the clipboard.  Then you can print this or save it as a document.
  6. In most most programs, even on the Desktop, instead of Right Click, Properties, you can press Alt+Enter.
  7. Anytime in a Windows program you get somewhere you really do not want to be press the Esc key in the upper left hand corner of your keyboard.  This is the same thing as clicking on the Cancel Button.  It will make the quick menu go away when you have right clicked by mistake.
  8. To Avoid the "Run away mouse" when selecting text or cells hold down the Shift key and press one of the Arrow keys until you have finished your selection.
  9. In Access, to Bring up the Database Window: Press F11
  10. In Microsoft Internet Explorer to automatically insert the www. at the front and the .com at the end of a URL.  Type the website name like entre-roanoke and press Ctrl+Enter.
  11. To Double Underline in Word: Hold down the Ctrl key and the Shift key and press the D key.
  12. To Move the contents of one cell to another In Excel: Point to the cell until you see a white arrow.  Hold down the left mouse button and drag the mouse pointer to the cell you want to move to.  Let go of the mouse button.
  13. In PowerPoint, to Duplicate a Slide in the Slide Sorter view : Select the slide to duplicate, down the Ctrl key and press D
  14. To select an entire paragraph in Word: Place the I-beam pointer anywhere in the paragraph and click three times.
  15. In Access, to move to the Next record same field: Hold down the Ctrl key and press Page Down
  16. In Access, to move to the Previous record same field: Hold down the Ctrl key and press Page Up
  17. To Link the Contents of one cell to another cell in Excel: Point to the border of the cell until you see a white arrow. Drag with the Right mouse button to the cell in which to place the link, let go of the mouse button. Click on Link Here.
  18. To Increase the Font Size in Word, PowerPoint and FrontPage: Hold down the Ctrl and Shift key and press the > symbol.
  19. To Decrease the Font Size in Word, PowerPoint and FrontPage: Hold down the Ctrl and Shift key and press the < symbol.
  20. To make the Format Painter button Sticky: Double-Click on the format Painter button on the Toolbar of Microsoft Office Applications to be able to paint the format of a selection over and over.
  21. To Capitalize the First Letter of a word in Word: Hold down the Shift key and press down the F3 key until the capitalization is what you want.
  22. To Automatically Change the Width of a Column to Fit the Widest Entry
  23. In a Word Table: Position the mouse pointer at the right most edge of the column until you see a black two-headed arrow pointing left and right.  Double-Click.
  24. In Excel: Position the mouse pointer between the Gray Lettered Column heading until you see a black two-headed arrow pointing left and right.  Double-Click.
  25. In Access: Position the mouse pointer between the Gray Named Column heading until you see a black two-headed arrow pointing left and right.  Double-click.
  26. To Remove all Borders from a Word Table, make sure your flashing cursor is in the table, then hold down the Alt and Ctrl keys, then type a U.
  27. To Copy a Formula down a column in Excel, get the Fill Pointer (+) by pointing to the bottom right-hand corner of the cell with the formula and double-click.
  28. To select All, in almost every Windows Program including Word, Excel, PowerPoint, Outlook and Access, just hold down the Ctrl key and type an A.
  29. To exit any Windows program, you can just hold down the Alt key and press the F4 key.  This is especially important to know if your mouse stops working or if you use a laptop.