Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This is the stupidest question you can imagine. I don't use the powerful
functions of Excel often enough that I remember them. I got help when I needed it and now can't even remember what the question I asked at the time. The help I got explained that when I finished, the function would be enclosed in curly brackets. Now I can't remember what kind of expression it is so I can't look up help for it. And of course when I look at the function the curly brackets disappear and I can't remember the key sequence to make them work again. What do I have to do to make the function work again? Thanks for not laughing at me. Ben Karlin St. Louis, Missouri |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Ben,
You are talking about an "array formula". You hold Control-Shift and press Enter. This will put the brackets in there for you. Hope that helps. "Ben Karlin" wrote: This is the stupidest question you can imagine. I don't use the powerful functions of Excel often enough that I remember them. I got help when I needed it and now can't even remember what the question I asked at the time. The help I got explained that when I finished, the function would be enclosed in curly brackets. Now I can't remember what kind of expression it is so I can't look up help for it. And of course when I look at the function the curly brackets disappear and I can't remember the key sequence to make them work again. What do I have to do to make the function work again? Thanks for not laughing at me. Ben Karlin St. Louis, Missouri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding and deleting question marks | Excel Discussion (Misc queries) | |||
Summary Page Question | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |