Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restrictions On Merged Cells?
I have created a form and it appears that there is a restirction on the number of lines/characters that can go in this merged area. I am set up as merged/wrap text/shrink to fit but after 8 lines, any following data entered goes off the form as if "wrap text" is not there. Also, it doesn't show up on print preview. How can I get around this, as the requirement for this form may be much more than 8 lines? Bob -- RERICE ------------------------------------------------------------------------ RERICE's Profile: http://www.excelforum.com/member.php...o&userid=34008 View this thread: http://www.excelforum.com/showthread...hreadid=537705 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restrictions On Merged Cells?
RERICE,
It's my understanding that merging cells in Excel is not desirable. If you need to make a form, its better to use borders to create regions, and include as many cells in the borders as you need for aesthetics. You can use "center across selection" to fine-tune some of your text positioning, and turn off gridlines as your form is designed, leaving the borders you turned on to view and print. HTH Beege "RERICE" wrote in message ... I have created a form and it appears that there is a restirction on the number of lines/characters that can go in this merged area. I am set up as merged/wrap text/shrink to fit but after 8 lines, any following data entered goes off the form as if "wrap text" is not there. Also, it doesn't show up on print preview. How can I get around this, as the requirement for this form may be much more than 8 lines? Bob -- RERICE ------------------------------------------------------------------------ RERICE's Profile: http://www.excelforum.com/member.php...o&userid=34008 View this thread: http://www.excelforum.com/showthread...hreadid=537705 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restrictions On Merged Cells?
Per Help/Specifications, each cell will display only the first 1024
characters (even if merged). You can get around this by manually entering a line feed character (Option-Enter) at least every 1024 chars. In article , RERICE wrote: I have created a form and it appears that there is a restirction on the number of lines/characters that can go in this merged area. I am set up as merged/wrap text/shrink to fit but after 8 lines, any following data entered goes off the form as if "wrap text" is not there. Also, it doesn't show up on print preview. How can I get around this, as the requirement for this form may be much more than 8 lines? Bob |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restrictions On Merged Cells?
Too late-the form has been created with merged cells and is in use. Is there a way to get around the problem I'm seeing with the restriction in # of lines? Bob -- RERICE ------------------------------------------------------------------------ RERICE's Profile: http://www.excelforum.com/member.php...o&userid=34008 View this thread: http://www.excelforum.com/showthread...hreadid=537705 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restrictions On Merged Cells?
JE McGimpsey Wrote: Per Help/Specifications, each cell will display only the first 1024 characters (even if merged). You can get around this by manually entering a line feed character (Option-Enter) at least every 1024 chars. In article , RERICE wrote: I have created a form and it appears that there is a restirction on the number of lines/characters that can go in this merged area. I am set up as merged/wrap text/shrink to fit but after 8 lines, any following data entered goes off the form as if "wrap text" is not there. Also, it doesn't show up on print preview. How can I get around this, as the requirement for this form may be much more than 8 lines? Bob what keystrokes do I use for the linefeed? -- RERICE ------------------------------------------------------------------------ RERICE's Profile: http://www.excelforum.com/member.php...o&userid=34008 View this thread: http://www.excelforum.com/showthread...hreadid=537705 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restrictions On Merged Cells?
Opt/Alt-Enter
In article , RERICE wrote: what keystrokes do I use for the linefeed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
Linking Merged Cells | Excel Worksheet Functions | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) |