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.
October 27th, 2008 at 8:00 PM
[...] – bookmarked by 5 members originally found by shugotenshineko on 2008-10-07 Keyboard Shortcuts – Part 2 – The Function Keys [...]
March 22nd, 2009 at 7:29 AM
[...] Excel Keyboard Shortcuts – Part 2 Share and Enjoy: [...]
March 23rd, 2009 at 3:30 PM
[...] Excel Keyboard Shortcuts Part 2 [...]