How do you format a row to break accross pages in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that this can be done easily in a table of a Word document, but is it
possible in Excel??
 
Highlight the column that you want to create a page break on...
For example, if you want Col A thru D on page 1 and Col E thru G on page 2,
highlight Col E then...
INSERT / PAGE BREAK

HTH,
 
Hi Gary,

Thank you for replying-- actually, I have a cell that has a lot of text in
it, and instead of splitting that text accross two pages, excel keeps all the
text together on one page, and consequently leaves a big gap on the previous
page, since it didn't fit on that page. I am trying to see if I can break
that cell across the pages, so that it prints even amount of information/text
on each page. Does this help to clarify my question??

Thanks!
DD
 
DD wrote...
....
. . . I am trying to see if I can break
that cell across the pages, so that it prints even amount of information/text
on each page. . . .
....

Impossible. Excel will *ALWAYS* print as much as it can of individual
cell contents on the *SAME* printout page. Putting this another way,
Excel lacks the ability to distribute the visible result of cells
across printout pages.
 
THANK YOU! As much as this is frustrating, it at least gives me a definitive
answer to my searching and fiddling around with excel. I appreciate your
response!

DD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top