ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula Prompts (https://www.excelbanter.com/excel-discussion-misc-queries/194628-formula-prompts.html)

Rob L

Formula Prompts
 
Is it possible, using Excel 2000, to get the "prompts" when I start typing a
formula ?

At work (on XL 2003) when I type (for instance) "=vlookup(" the formula pops
up with the variable or input required as a prompt. This doesn't happen at
home with XL 2000, and I would ike it to iff possible.

Thanks

Rob L



Dave Peterson

Formula Prompts
 
That's one of the features added in newer versions of excel.

But you could type:
=vlookup(
and then hit ctrl-shift-a

or maybe you'd like to try:
=vlookup(
ctrl-a

Rob L wrote:

Is it possible, using Excel 2000, to get the "prompts" when I start typing a
formula ?

At work (on XL 2003) when I type (for instance) "=vlookup(" the formula pops
up with the variable or input required as a prompt. This doesn't happen at
home with XL 2000, and I would ike it to iff possible.

Thanks

Rob L


--

Dave Peterson

Rob L

Formula Prompts
 
Thanks for that Dave. Ctrl+Shift+a give me what I'm after....

Rob

"Dave Peterson" wrote in message
...
That's one of the features added in newer versions of excel.

But you could type:
=vlookup(
and then hit ctrl-shift-a

or maybe you'd like to try:
=vlookup(
ctrl-a

Rob L wrote:

Is it possible, using Excel 2000, to get the "prompts" when I start
typing a
formula ?

At work (on XL 2003) when I type (for instance) "=vlookup(" the formula
pops
up with the variable or input required as a prompt. This doesn't happen
at
home with XL 2000, and I would ike it to iff possible.

Thanks

Rob L


--

Dave Peterson





All times are GMT +1. The time now is 09:03 AM.

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