Showing posts with label excel shortcuts. Show all posts
Showing posts with label excel shortcuts. Show all posts

Monday, August 22, 2011

Shortcut function keys in excel


Here is a list of shortcut keys in Microsoft Excel.
  1. F1: Opens a help task pane
  2. F1 + Ctrl: Opens or closes the help window
  3. F2: To edit the text in the active cell
  4. F2 + Shift: To write a comment in the active cell
  5. F2 + Alt: Opens the save as dialog box
  6. F3 + Shift: opens the insert dialog box
  7. F3 + Ctrl: Opens the define name dialog box
  8. F3 + Shift + Ctrl:  Opens the create name dialog box
  9. F4:  To redo the last command
  10. F4 + Ctrl: To close the workbook window
  11. F4 + Alt: To close the excel program
  12. F5: Opens the Goto dialog box
  13. F5 + Ctrl: brings back to the first level of workbook
  14. F6: To shift between help taskbar and the excel window
  15. F6 + Shift: To goto the previous square in the open worksheet