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
Link to this post!
