Solved how do I keep merged cells together when printing?

April 14, 2016 at 08:30:14
Specs: Windows XP
I don't remember how to format my excel document to keep it from splitting up merged cells between pages when printing

message edited by laurazik


See More: how do I keep merged cells together when printing?

Report •


#1
April 14, 2016 at 12:05:30
Would setting (defining) the printing area allow i?

Report •

#2
April 14, 2016 at 15:57:53
✔ Best Answer
You can set page breaks to force the splitting of pages where required.

Will that help?

message edited by DerbyDad03


Report •

#3
April 20, 2016 at 13:40:20
In Microsoft Excel, we can set print area to print only selected cell ranges in active worksheet with following steps:

1. Hold down the Ctrl key to select the non-contiguous ranges.

2. Click Page Layout > Print Area > Set Print Area.

3. Then the selected ranges will be surrounded by a dotted line, and then click File > Print to start printing the ranges one by one.

Notes:

1. This Set Print Area command only allows you to select and print cell ranges in the active worksheet. If you switch to another worksheet, the previous set print areas will be cleared.

2. All selected non-contiguous print areas are separated with page breaks. Each range will be printed into one page, which may waste a lot of paper and printer ink.

3. If you need add another cell ranges into the print area, you can select the cells ranges firstly, and then click the Add to Print Area command item. As well, you can release the selected ranges by clicking Clear Print Area..

Regards,
Judy Smith | Tech Support
O365cloudexperts


Report •

Related Solutions

#4
April 20, 2016 at 14:35:06
Ms. Smith,

Please explain how this addresses the OP's question related to preventing Excel
from splitting up merged cells between pages when printing.

We eagerly await your response.

Thank you.

message edited by DerbyDad03


Report •


Ask Question