Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting single, unmerged cells over 2 printed pages
Maybe it's a simple fix that I don't know about or can't find, but can
anyone tell me how to split a single cell over two pages. At the moment if the cell becomes too big to fit in the remaining space at the bottom of the current page it moves the entire cell to the next page - leaving a big gap. I am using the form I have created in a database/mailmerge role - printing out about 250 records with text fields of differing sizes - so it is not practical to manually split the one cell into two for each record. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting single, unmerged cells over 2 printed pages
Excel has no "widows and orphans" functions.
You must split the cell contents into two or more cells. Gord Dibben MS Excel MVP On 14 Apr 2007 13:31:33 -0700, wrote: Maybe it's a simple fix that I don't know about or can't find, but can anyone tell me how to split a single cell over two pages. At the moment if the cell becomes too big to fit in the remaining space at the bottom of the current page it moves the entire cell to the next page - leaving a big gap. I am using the form I have created in a database/mailmerge role - printing out about 250 records with text fields of differing sizes - so it is not practical to manually split the one cell into two for each record. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column names on all printed pages | Excel Worksheet Functions | |||
Watermark on all printed pages in Excel | Excel Discussion (Misc queries) | |||
Make it possible to split unmerged cells again!!! | Excel Worksheet Functions | |||
i would like that my first line to appear in all printed pages | Excel Discussion (Misc queries) | |||
headers across printed pages | Excel Worksheet Functions |