| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot see formula descriptions in worksheet as I type a formula.
When I type a formula into the worksheet I do not get the little box
underneath that gives the formula description (ex. NPV(rate,value1, value2... box does not come up). Does anyone know how to change my Excel set-up so that it will show as I type? Any help much appreciated. Thanks, RL |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot see formula descriptions in worksheet as I type a formula.
Goto ToolsOptionsGeneral tabFunction tooltips
Biff "RABL33" wrote in message oups.com... When I type a formula into the worksheet I do not get the little box underneath that gives the formula description (ex. NPV(rate,value1, value2... box does not come up). Does anyone know how to change my Excel set-up so that it will show as I type? Any help much appreciated. Thanks, RL |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot see formula descriptions in worksheet as I type a formula.
Greatly appreciate the answer and was able to verify on Excel 2003.
Unfortunately, my machine is running Excel 2000 and that option is not available. Any add-ins for this or some other workaround? Thanks again, RL T. Valko wrote: Goto ToolsOptionsGeneral tabFunction tooltips Biff "RABL33" wrote in message oups.com... When I type a formula into the worksheet I do not get the little box underneath that gives the formula description (ex. NPV(rate,value1, value2... box does not come up). Does anyone know how to change my Excel set-up so that it will show as I type? Any help much appreciated. Thanks, RL |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot see formula descriptions in worksheet as I type a formula.
I don't know if this works on other versions....
CTRL SHIFT A Start typing the formula: =NPV( After you type in the ( then use the key combo of CTRL SHIFT A and the arguments will show. It doesn't work like the regular function tooltips, though! In fact, it seems like a pita but at least it'll show you what the arguments are supposed to be. Biff "RABL33" wrote in message ups.com... Greatly appreciate the answer and was able to verify on Excel 2003. Unfortunately, my machine is running Excel 2000 and that option is not available. Any add-ins for this or some other workaround? Thanks again, RL T. Valko wrote: Goto ToolsOptionsGeneral tabFunction tooltips Biff "RABL33" wrote in message oups.com... When I type a formula into the worksheet I do not get the little box underneath that gives the formula description (ex. NPV(rate,value1, value2... box does not come up). Does anyone know how to change my Excel set-up so that it will show as I type? Any help much appreciated. Thanks, RL |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot see formula descriptions in worksheet as I type a formula.
Works on Excel 2000. Thanks again, much appreciated.
RL T. Valko wrote: I don't know if this works on other versions.... CTRL SHIFT A Start typing the formula: =NPV( After you type in the ( then use the key combo of CTRL SHIFT A and the arguments will show. It doesn't work like the regular function tooltips, though! In fact, it seems like a pita but at least it'll show you what the arguments are supposed to be. Biff "RABL33" wrote in message ups.com... Greatly appreciate the answer and was able to verify on Excel 2003. Unfortunately, my machine is running Excel 2000 and that option is not available. Any add-ins for this or some other workaround? Thanks again, RL T. Valko wrote: Goto ToolsOptionsGeneral tabFunction tooltips Biff "RABL33" wrote in message oups.com... When I type a formula into the worksheet I do not get the little box underneath that gives the formula description (ex. NPV(rate,value1, value2... box does not come up). Does anyone know how to change my Excel set-up so that it will show as I type? Any help much appreciated. Thanks, RL |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot see formula descriptions in worksheet as I type a formula.
You're welcome. Thanks for the feedback!
Those function tooltips come in handy when you're 6 nested levels deep in a real complex formula! Biff "RABL33" wrote in message oups.com... Works on Excel 2000. Thanks again, much appreciated. RL T. Valko wrote: I don't know if this works on other versions.... CTRL SHIFT A Start typing the formula: =NPV( After you type in the ( then use the key combo of CTRL SHIFT A and the arguments will show. It doesn't work like the regular function tooltips, though! In fact, it seems like a pita but at least it'll show you what the arguments are supposed to be. Biff "RABL33" wrote in message ups.com... Greatly appreciate the answer and was able to verify on Excel 2003. Unfortunately, my machine is running Excel 2000 and that option is not available. Any add-ins for this or some other workaround? Thanks again, RL T. Valko wrote: Goto ToolsOptionsGeneral tabFunction tooltips Biff "RABL33" wrote in message oups.com... When I type a formula into the worksheet I do not get the little box underneath that gives the formula description (ex. NPV(rate,value1, value2... box does not come up). Does anyone know how to change my Excel set-up so that it will show as I type? Any help much appreciated. Thanks, RL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula stops working after re-opening worksheet | Excel Worksheet Functions | |||
| Index match formula works in for one worksheet reference but not another | Excel Worksheet Functions | |||
| Worksheet from Formula | Excel Worksheet Functions | |||
| Offset formula on different worksheet | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
Linear Mode
