ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula pop-up box (https://www.excelbanter.com/excel-discussion-misc-queries/23077-formula-pop-up-box.html)

NKH.UofW

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.

Debra Dalgleish

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


NKH.UofW

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

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



All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com