Splitting cells over two pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Candid - 24 Jun 2004 06:17 GMT

Can someone tell me if it is possible to set Excel up to print a large cell over two pages? I have tried many times and Excel either pushes the entire cell onto the first or second page but not split it over both.

Thanks in advance.

Reply to this Message

Paul Cundle - 24 Jun 2004 23:08 GMT

Surely the point of a cell is that, by definition, it is the basic unit used
and should not be split?

Anyway, I have briefly tried to think of a solution to your question, but
honestly cannot think of a reason why you would want to do this and so an
answer isn't springing to mind. If you could provide an example or explain
in a little more detail, perhaps I or somebody else could help.

Paul C,

Signature

> Can someone tell me if it is possible to set Excel up to print a
> large cell over two pages? I have tried many times and Excel either
> pushes the entire cell onto the first or second page but not split it
> over both.
>
> Thanks in advance.

Reply to this Message

Candid - 27 Jun 2004 16:49 GMT

Paul,

I will try to clarify my requirement. I have a multipage (100 plus) spreadsheet that I am continually editing. What happens is that any additions to a particular cell will shift the way the pages print. What I want to happen is similar to what Word does when you insert a table: "Allow row to break across pages". I hope this clarifies things a little more.

Thanks.

> Surely the point of a cell is that, by definition, it is the basic unit used
> and should not be split?
[quoted text clipped - 11 lines]
> >
> > Thanks in advance.

Reply to this Message

Paul Cundle - 27 Jun 2004 18:34 GMT

I think I see what you mean now - had originally assumed you wanted to split
a cell over two pages side-by-side rather than one above the other.

I'm almost certain you can't split a cell over pages, unfortunately.

I assume the problem cells contain a long text string? You could split the
row into several separate rows so that some of the text is in the cells on
the first page and the rest of the text is in the cells on the second page.
It's not a very elegant solution (and may not even work, depending on how
well I've understood the circumstances), but when you make changes you could
use the option Edit-->Fill-->Justify to simplify the reflowing of text as
appropriate. (This option in Excel is quite different to the Justify option
for text in Word).

Paul C,

Signature

> Paul,
>
[quoted text clipped - 29 lines]
>>>
>>> Thanks in advance.

Reply to this Message