Trouble with Print Area

N

nikwak

?I am having a problem with Print Area. I highlight the area I want to print
at the top of the Excel sheet and then I add another area further down the
sheet. The problem is that the area I had down the sheet has a different
page break and therefore the sheet won't print out as I would like it to do.
Can anyone help?

Nick
 
L

Liana

Hi Nick,
Do you mean you are assigning multiple print area ranges (for example,
rows 1-5 and rows 12-20)? And suppose you have a page break inserted
between rows 15 and 16, then your page will break there, even if all
the rows would normally fit on one page? Does this happen with both
manually inserted page breaks, and auto-assigned (by Excel) page
breaks?
Liana
 

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

Similar Threads

Adding a comment in a footnote area 1
Problem with printing a word document containing a table 0
Document won't print 0
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Mail Merge Help 1
Print only rows with data in them 0
Page numbering with Merged Document and IF statements 1
Limiing extent of printout 3

Top