Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel software training london - printing big cells cut

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training london - Printing big cells cut by a page break problems to resolve

excel software training london - Printing big cells cut by a page break problems to resolve

ResolvedVersion Standard

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

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.