Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you format a row to break accross pages in Excel?
I know that this can be done easily in a table of a Word document, but is it
possible in Excel?? |
#2
|
|||
|
|||
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, -- Gary Brown "DD" wrote: I know that this can be done easily in a table of a Word document, but is it possible in Excel?? |
#3
|
|||
|
|||
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 "Gary Brown" wrote: 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, -- Gary Brown "DD" wrote: I know that this can be done easily in a table of a Word document, but is it possible in Excel?? |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 "Harlan Grove" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
protecting format | Excel Discussion (Misc queries) | |||
How do I delete pages? | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Importing French (Canadian) format html pages | Setting up and Configuration of Excel |