ShortcutdrillExcel shortcuts / formula / Insert a function by name
Insert a function by name in Excel: Shift+F3, type the name, Enter (Mac: Fn+Shift+F3)
| Windows | Shift+F3, type the name, Enter |
|---|---|
| Mac | Fn+Shift+F3 |
| Group | formula |
Drill: Insert a function by name. Pro drill. Twenty-five drills are free.
What it does and when to use it
Shift+F3 opens Insert Function with the search box ready. Type the name, press Enter, and the formula starts with the function and its argument prompts. Useful for a function whose arguments you half remember.
The common mistake
Using it for SUM and AVERAGE, where typing the formula is quicker. It earns its keep on SUMIFS, XLOOKUP and the financial functions.
Related shortcuts
- Add a note to a cell Shift+F2, type, Esc
- Repeat the last action F4 (or Ctrl+Y)
- Lock a reference with F4 F2, F4
- Make a reference absolute F2, F4, Enter
- Evaluate part of a formula F2, select the part, F9, Esc
- The printable cheat sheet
Questions
How do I see the arguments of a function?
Type the function name and the opening bracket, then Ctrl+A for the Function Arguments dialog, or Ctrl+Shift+A to insert the argument names.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill