Monday, December 5, 2011

Microsoft Excel Function Keys Shortcuts!!!!!!!!!!

   Most of the user know at least a handful of shortcuts for Microsoft Excel. However, an entire row of function keys shortcut  is often neglected and even unknown to users. We are talking about the function keys that they just do not get enough attention from users of Microsoft Excel.
So let’s talk about Microsoft  Excel Function Keys, from left to right.
  • F1 by itself opens the Help task pane.
  • Ctrl+F1 shows or hides the Ribbon newer versions of Excel.
  • Alt+F1 will create a quick chart using data that is selected.
  • Alt+Shift+F1 inserts a brand new worksheet/macro sheet.
  • F2 moves the cursor to the end of the selected cell (edit cell mode).
  • Ctrl+F2 shows  Print Preview Window.
  • Alt+F2 brings up the Save As dialog.
  • Shift+F2 adds a comment.
  • F3 opens the Paste Name box.
  • Shift+F3 is a quick way to insert a function.
  • F4  repeats your last action.
  • Ctrl+F4 closes your window.
  • F5 opens the Go To dialog.
  • Ctrl+F5 restores the window size.
  • F6 switches to the task pane or second window.
  • F7 brings up Spell Check.
  • Shift+F7 opens the Research pane.
  • F8 turns on (or off) extended mode.
  • Shift+F8 allows you to add another range of cells to the selection.
  • F9 calculates all open workbooks.
  • Shift+F9 calculates the active worksheet.
  • F10 turns key tips on or off.
  • Ctrl+F10 maximizes or restores the window.
  • F11  creates an instant chart.
  • F12 brings up the Save As dialog.
  • Shift+F12 for the Save window.
  • Ctrl+F12 opens theOpen dialog.
That's all for Today, and keep in mind some of shortcuts also works in other Microsoft Office programs too, other shortcuts will be published soon!
Enjoy Micorsoft Excel.........

No comments:

Post a Comment