Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format changes in a merged cell
I have 9 columns and 10 rows merged in order to type text. Because I have
many lines of text (25 rows at least) I have expanded the last row in order to see all the text. The merged cell is formated for centering but once I get past row 25 it becomes right justified. I have deleted the cells and started over but it always changes formatting at about 25 lines of text. Regards, Paul |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format changes in a merged cell
Hi,
the answer is version dependent: 2003: Cells can contain 1024 characters in a formula Cells can contain 32,767 text characters but only the first 1023 will be visible (unless you use Alt Enter to force line breaks) this is probably the problem you are experiencing above - the first 1023 characters wiil be visible, although while you type you see more, but with alignment not the same. In 2003 your solution is to use Alt Enter as stated above. 2007: Cells can contain 8192 characters in formulas Cells can contain 32,767 text characters in cells and all can be seen and printed without needing to use Alt Enter. -- If this helps, please click the Yes button Cheers, Shane Devenshire "P_Kellogg" wrote: I have 9 columns and 10 rows merged in order to type text. Because I have many lines of text (25 rows at least) I have expanded the last row in order to see all the text. The merged cell is formated for centering but once I get past row 25 it becomes right justified. I have deleted the cells and started over but it always changes formatting at about 25 lines of text. Regards, Paul |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format changes in a merged cell
Thank you, Shane. This helps.
I am using 2003 and ALT Enter. I must be reaching the 32,767 character limit. As a follow-up, do you know how excel counts characters? By using ALT Enter and placing 1 character per line, could you have 32,767 lines or does Excel count the potential spaces on the line as characters? Thank you again for the support. Paul "Shane Devenshire" wrote: Hi, the answer is version dependent: 2003: Cells can contain 1024 characters in a formula Cells can contain 32,767 text characters but only the first 1023 will be visible (unless you use Alt Enter to force line breaks) this is probably the problem you are experiencing above - the first 1023 characters wiil be visible, although while you type you see more, but with alignment not the same. In 2003 your solution is to use Alt Enter as stated above. 2007: Cells can contain 8192 characters in formulas Cells can contain 32,767 text characters in cells and all can be seen and printed without needing to use Alt Enter. -- If this helps, please click the Yes button Cheers, Shane Devenshire "P_Kellogg" wrote: I have 9 columns and 10 rows merged in order to type text. Because I have many lines of text (25 rows at least) I have expanded the last row in order to see all the text. The merged cell is formated for centering but once I get past row 25 it becomes right justified. I have deleted the cells and started over but it always changes formatting at about 25 lines of text. Regards, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
How to maintain merged cell format when cutting the content away | Excel Worksheet Functions | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
format a merged cell to grow (Heighth) | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |