Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula pop-up box
Using Excel 2002, when I start to enter a formula in a cell, for example,
=sum( I get this little box that pops up right in my way, showing me how I might like to complete it the formula. Does anyone know how to turn this thing off so it doesn't pop up all the time? Thanks very much. |
#2
|
|||
|
|||
Choose ToolsOptions
Select the General tab Remove the check mark from 'Function tooltips' Click OK NKH.UofW wrote: Using Excel 2002, when I start to enter a formula in a cell, for example, =sum( I get this little box that pops up right in my way, showing me how I might like to complete it the formula. Does anyone know how to turn this thing off so it doesn't pop up all the time? Thanks very much. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
THANK YOU!!!!!
nh "Debra Dalgleish" wrote: Choose ToolsOptions Select the General tab Remove the check mark from 'Function tooltips' Click OK NKH.UofW wrote: Using Excel 2002, when I start to enter a formula in a cell, for example, =sum( I get this little box that pops up right in my way, showing me how I might like to complete it the formula. Does anyone know how to turn this thing off so it doesn't pop up all the time? Thanks very much. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
You're welcome! If you ever need to see a function's arguments, as you
create a formula: Type the equal sign, function name, and opening parenthesis, e.g.: =MATCH( Then press Ctrl + Shift + a NKH.UofW wrote: THANK YOU!!!!! nh "Debra Dalgleish" wrote: Choose ToolsOptions Select the General tab Remove the check mark from 'Function tooltips' Click OK NKH.UofW wrote: Using Excel 2002, when I start to enter a formula in a cell, for example, =sum( I get this little box that pops up right in my way, showing me how I might like to complete it the formula. Does anyone know how to turn this thing off so it doesn't pop up all the time? Thanks very much. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |