auto Page break when field contents change?

Q

Questor

We are using a large excel spreadsheet with several
columns of sorted data. I currently have to manually place
page breaks between pages when a column of sorted data
changes from one record to the next

1.) I would like Excel to auto-insert a page break when
the field contents changes in a specific column.

2.) I would like each page break to start on a new
physical page. - ie we are using a duplex printer and page
breaks are currently auto-placed on the following paper.
How do I get Excel to print on a seperate piece of paper
for a page break rather than on the back of the current
page?
 

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

Mail Merge Directory Conditional Page Break 0
Page numbering with Merged Document and IF statements 1
Page breaks change during printing? 0
Mailmerge - page breaking to new customer 1
Images are pixelated when saving to PDF 0
Page Breaks 1
Page Break when a column changes 4
Publisher 2010 insert page break and importing Word docs 2

Top