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.

  1. F1 by itself opens the Help task pane.
  2. Ctrl+F1 shows or hides the Ribbon newer versions of Excel.
  3. Alt+F1 will create a quick chart using data that is selected.
  4. Alt+Shift+F1 inserts a brand new worksheet/macro sheet.
  5. F2 moves the cursor to the end of the selected cell (edit cell mode).
  6. Ctrl+F2 shows  Print Preview Window.
  7. Alt+F2 brings up the Save As dialog.
  8. Shift+F2 adds a comment.
  9. F3 opens the Paste Name box.
  10. Shift+F3 is a quick way to insert a function.
  11. Ctrl+F3 brings up the Name Manager dialog.
  12. Ctrl+Alt+F3 brings up the New Name dialog.
  13. Ctrl+Shift+F3 brings up the Create Names dialog.
  14. F4  repeats your last action.
  15. Ctrl+F4 closes your window.
  16. Shift+F4 Move you to Firs Cell A1.
  17. F5 opens the Go To dialog.
  18. Ctrl+F5 restores the window size.
  19. Shift+F5 Brings up Find and Replace dialog.
  20. F6 switches to the task pane or second window.
  21. Ctrl+F6 switches between workbooks.
  22. F7 brings up Spell Check.
  23. Shift+F7 opens the Research pane.
  24. F8 turns on (or off) extended mode.
  25. Shift+F8 allows you to add another range of cells to the selection.
  26. Alt+F8 brings up Macro dialog.
  27. F9 calculates all open workbooks.
  28. Shift+F9 calculates the active worksheet.
  29. Ctrl+F9 minimizes workbooks.
  30. F10 turns key tips on or off.
  31. Ctrl+F10 maximizes or restores the window.
  32. Shift+F10 brings up Shortcut Menu.
  33. F11  creates an instant chart.
  34. Ctrl+F11  creates an instant Macro Sheet.
  35. Alt+F11  opens Microsoft VBA Window.
  36. Shift+F11  insert new worksheet in current workbook.
  37. F12 brings up the Save As dialog.
  38. Shift+F12 for the Save window.
  39. Ctrl+F12 opens theOpen dialog.
  40. Ctrl+Shift+F12 brings the Print dialog.
That’s all for Today, and keep in mind some of the shortcuts also works in other Microsoft Office programs too, other shortcuts will be published soon!
ILYAS QASIM
Advertisements

The URI to TrackBack this entry is: https://powertipsntricks.wordpress.com/2011/11/05/microsoft-excel-function-keys-shortcuts/trackback/

RSS feed for comments on this post.

One CommentLeave a comment

  1. […] #split {}#single {}#splitalign {margin-left: auto; margin-right: auto;}#singlealign {margin-left: auto; margin-right: auto;}#splittitlebox {text-align: center;}#singletitlebox {text-align: center;}.linkboxtext {line-height: 1.4em;}.linkboxcontainer {padding: 7px 7px 7px 7px;background-color:#eeeeee;border-color:#000000;border-width:0px; border-style:solid;}.linkboxdisplay {padding: 7px 7px 7px 7px;}.linkboxdisplay td {text-align: center;}.linkboxdisplay a:link {text-decoration: none;}.linkboxdisplay a:hover {text-decoration: underline;} function opensingledropdown() { document.getElementById('singletablelinks').style.display = ''; document.getElementById('singlemouse').style.display = 'none'; } function closesingledropdown() { document.getElementById('singletablelinks').style.display = 'none'; document.getElementById('singlemouse').style.display = ''; } Using Excel statistical functions for trend analysis.Microsoft Excel Function Keys Shortcuts! […]

    Like


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: