![]() |
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. |
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 |
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 |
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