Keyboard Shortcuts – Part 2 – The Function Keys

We continue our series of lessons on Excel Keyboard shortcuts. In this video training, I demonstrate how each of the 12 Function keys serve as shortcuts.


The keyoard shotcuts that I use most frequently are:

  • F2 – to activate “in-cell” editing. Double-clicking a cell does the same thing – your choice!
  • F3 – To “paste a name” into a formula. (Of course you must have already created or defined named cells, ranges and constants for this to work.)
  • F5 – To go to any cell reference or named range. Explore the “Special” dialog box to “Go to” e.g. cells containing specific types of formulas – a great auditing feature!
  • f7 – To spell check you spreadsheet – great shortcut!
  • F11 – To insert a chart on a new worksheet with a 1-key shortcut. You can edit the chart once it is created.
  • F12 – Brings up the File, “Save As” dialog box – not many people know this shortcut.

Find the Excel Video Training Lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now availabe to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons