Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

Excel Formula Entry Shortcuts

August 2, 2016 by terp Leave a Comment

How Can I Save Time When Entering Formulas?

Tip #1

When entering a formula, you don’t always need to spell out the entire function.

You only need to spell the function until it becomes the only one on the list Excel automatically provides to help guide you.   E.g., below are two scenarios – the first when you type in just ‘V’, and the second when you type in ‘VL’.  You can see that adding the ‘L’ narrows it down to only VLOOKUP, at which point you can just hit Tab and enter your parameters (Tab will automatically put in the first parenthesis for you).

excel-entering-formulas-vlookup

Tip #2

Once you’ve entered your parameters (completed your formula) you don’t have to type the closing parenthesis – just hit Enter and Excel will enter it for you automatically.  You can do this with Excel formulas in general, not just VLOOKUP.

Combining these two methods will save you keystrokes.  And every keystroke counts!

Filed Under: Formulas Tagged With: Excel Formulas, Excel Shortcuts

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel