Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do it in excel?
Does anyone have any suggestions on how to do it in excel?
When I combine 4 cells into a big cell, and type in the formula. This formula requires to key in Ctrl+Shift+Enter to activate the formula function. I can key in Ctrl+Shift+Enter within a single cell, but I cannot do it in a big cell, which is combined by a number of cells. Does anyone have any suggestions on how to key in Ctrl+Shift+Enter into a big cell? Thanks in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do it in excel?
"Eric" wrote in message
... Does anyone have any suggestions on how to do it in excel? When I combine 4 cells into a big cell, and type in the formula. This formula requires to key in Ctrl+Shift+Enter to activate the formula function. I can key in Ctrl+Shift+Enter within a single cell, but I cannot do it in a big cell, which is combined by a number of cells. Does anyone have any suggestions on how to key in Ctrl+Shift+Enter into a big cell? Thanks in advance for any suggestions Eric You cannot use array formulas in merged cells. Many people here recommend that you don't merge cells at all, since these cause all sorts of trouble. Perhaps if you tell us why you are merging cells, someone will suggest an alternative method, such that you can use array formulas. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do it in excel?
Hi,
Ctrl+Shift+enter is used to commit an array formula which aren't allowed in merged cells. Mike "Eric" wrote: Does anyone have any suggestions on how to do it in excel? When I combine 4 cells into a big cell, and type in the formula. This formula requires to key in Ctrl+Shift+Enter to activate the formula function. I can key in Ctrl+Shift+Enter within a single cell, but I cannot do it in a big cell, which is combined by a number of cells. Does anyone have any suggestions on how to key in Ctrl+Shift+Enter into a big cell? Thanks in advance for any suggestions Eric |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do it in excel?
Instead of merging the cells, use the horizontal alignment option of
"Center Across Selection". On Dec 5, 9:37 am, Eric wrote: Does anyone have any suggestions on how to do it in excel? When I combine 4 cells into a big cell, and type in the formula. This formula requires to key in Ctrl+Shift+Enter to activate the formula function. I can key in Ctrl+Shift+Enter within a single cell, but I cannot do it in a big cell, which is combined by a number of cells. Does anyone have any suggestions on how to key in Ctrl+Shift+Enter into a big cell? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|