Excel 2007 functions. What is missing ?

Sahak

Well-known Member
Joined
Nov 10, 2006
Messages
885
Hi All,

One of good advantages Excel 2007 is when I type for example “=v” it shows dropdown list of functions starting with “V” (VALUE, VAR, ..., VLOOKUP) & description of selected function, but after hitting “Tab” key it enters selected function & openes parentheses for example “=VLOOKUP(“ & waits for user, It doesn’t show what values needed to be entered like in Excel 2003 “VLOOKUP(lookup_value, table_array, col_index_num,[range_lookup]).
By the way In Excel Popular Options ScreenTip style set to “Show feature descriptions in ScreenTips
What is missing :confused:
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Albatros

New Member
Joined
Aug 31, 2011
Messages
26
You may have autocomplete turned off.

Turn Formula AutoComplete on or off


  1. Click the Microsoft Office Button
    ZA010077102.gif
    , click Excel Options, and then click the Formulas category.

  1. Under Working with formulas, select or clear Formula AutoComplete.
If it is on it should show the tooltip for the function arguments.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,783
Office Version
  1. 2010
Platform
  1. Windows
Excel Options > Advanced, > Display, tick Show function Screen Tips
 

Sahak

Well-known Member
Joined
Nov 10, 2006
Messages
885
Thank you SHG, It was it, now works.
Thank you Albatros for reply.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,783
Office Version
  1. 2010
Platform
  1. Windows
You're welcome, good luck.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,755
Messages
5,626,671
Members
416,200
Latest member
Pulsar3000

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top