| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I insert a ' } ' into excel so that I can adjust its size?
I suspect you are referring to an Array formula.
A simple array formula would be:- =Sum(IF($A$1:$A$10="Widgets",$B$1:$B$10)) when typed in you enter it by pressing Ctrl+Shift+Enter and the curly brackets appear. Mike "deepstevec" wrote: How do I insert a ' } ' so that I can adjust its size to incorporate a number of excel rows? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adjust automatically size margins | Excel Discussion (Misc queries) | |||
| How do I adjust the font size in a Combo Box? | Excel Discussion (Misc queries) | |||
| Adjust the size of cells automatically | Excel Discussion (Misc queries) | |||
| How would I adjust size for printing | Excel Discussion (Misc queries) | |||
| I can't adjust the window size of an active workbook. | Excel Discussion (Misc queries) | |||
Linear Mode
