| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is Ctrl + Shift + Enter ?
i was reading another post and came accross the tool Ctrl Shift Enter. What
is this? the following formula does not work if you enter it it in a cell and simply hit enter, but if you press Ctrl Shift Enter, Excel puts { } around the formula, and it works. the formula does NOT work if you type the {}'s manually. =AVERAGE(IF(array10,array1)) (array1 is the name of an array of numbers) how does one know when to use Ctrl Shift Enter? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shift option ctrl etc | Excel Discussion (Misc queries) | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| Multiple Criteria Sumif/Sum..tried & failed Ctrl+Shift+Enter, | Excel Discussion (Misc queries) | |||
| ctrl+shift+enter vs enter | Excel Discussion (Misc queries) | |||
| Ctrl+Shift+arrow | Excel Worksheet Functions | |||
Threaded Mode
