Wednesday, April 15, 2009

Shortcuts using Windows logo key

Press                                   To

Windows logo key                  Display or hide the Start menu

Windows logo key+L              Lock the computer

Windows logo key+BREAK -Display the System Properties dialog box

Windows logo key+D              Show the desktop

Windows logo key+M       Minimize all windows

Windows logo key+SHIFT+M   Restore minimized windows

Windows logo key+E         Open My Computer

Windows logo key+F             Search for a file or folder

CTRL+Windows logo key+F     Search for computers

Windows logo key+F1           Display Windows Help

Windows logo key+R             Open the Run dialog box

Windows logo key+U             Open Utility Manager

Application key                      Display the Shortcut menu for the selected item


Saturday, April 11, 2009

Top 10 Navigation Tips for Microsoft Excel

These are my top 10 Navigation Tips … I do them without thinking, but have recently had to show a few younger folks that using your mouse isn’t the most efficient way to navigate Excel.  For anyone else who needs a navigation refresher, these will make working in your spreadsheets much faster:

  1. [Ctrl]+[Home] takes you to cell A1
  2. [Ctrl]+[End] takes you to the last data cell in your worksheet
  3. [Ctrl]+[PgDn] takes you to the next worksheet
  4. [Ctrl]+[PgUp] takes you to the previous worksheet
  5. [End]+[↑] takes you to the top of the row
  6. [End]+[↓] takes you to the bottom of the row
  7. [End]+[→] takes you to the furthest right entry in the row
  8. [End]+[←] takes you to the furthest left entry  in the row
  9. [Ctrl]+[A] selects/highlights all cells that you are using in a worksheet
  10. [Shift]+[Spacebar] selects/highlights your row

http://businesstoolsblog.com/