Erasmo has attended:
No courses
Printing big cells cut by a page break problems to resolve
Dear friends,
This is my problem, maybe someone can help me with some macro to do what I need.
1)- When a big cell is cut by a page break the content of the cell is divided or printed only in one part of the cell. There is the possibility to repeat the printing of the content also in the other empty part of the cell which is in the precedent or successive page?
2)- A similar problem arrive with the borders of the cells cut by a page break; when it arrive, there is some missing borders because only are printed the borders of the entire cell, then at the end of the page there is the part of the cell without borders. There is a way to print borders around a part of the divided cell?
Thank you to everyone
Erasmo
RE: printing big cells cut by a page break problems to resolve
Erasmo,
1. Try to set the page to print smaller parts of the worksheet. Use FILE> PRINT PREVIEW to access the print preview. Then click PAGE BREAK PREVIEW. This will give some blue lines that you can drop and drag to set the pages manually.
2. If I understand your question, You might need to select all your cells, and then put a border around them all. Let us know if this works.
Richard