Just start typing to get the function you want in Excel — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Just start typing to get the function you want in Excel

by on
in Excel Training,Office Technology

Just start typing to get the function you want in Excel 2007 and 2010. A new type-ahead feature is now included for Excel functions.

Example: Start typing =VL and notice that the VLookUp function pops up in the dropdown list. If it’s at the top, press Tab and it will enter the function and open the left parenthesis. If it is not at the top of the list, you can either continue typing until it is, or use your down arrow key to select the function you want, followed by the Tab key to enter it.

{ 2 comments… read them below or add one }

vba August 29, 2012 at 5:12 pm

Learn vlookup, excel hlookup, sumif , vba etc.We are excel consultant and access programmer with expertise in advanced Excel formulas, modeling, macros, and VBA.

Reply

Excel Expert August 29, 2012 at 8:13 am

We are excel consultants and excel expert, Having 15+ years experience with Excel and Access programming, VBA (for programming in Excel and Access) MySQL, Oracle, ODBC, PHP, and much more.

Reply

Leave a Comment