How To: Pivot Tables, Keep data together when printing.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi TWIMC,

I'd like to be able to keep together related data when printing, in that if
a set of data is to be chopped in two, move or insert a page break after the
previous field item. I now there's the field option 'Insert page break after
each item', but occasionally there are items will a small set of data and
several of these could fit on one page, so the question is can I keep related
data together, like I can say in an Access data report on the sorting and
grouping of a field.

TIA
KM
 
No, Excel doesn't have that option. You can manually adjust the page
breaks, in View>Page Break Preview.
 
You must log in or register to reply here.

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

Lock lines together to creat pivot table? 3
Keep Text Together 1
Get visible pivot table items 4
Unable to Group in Pivot Table 1
Pivot Table Deconstruction 2
Pivot table automation 1
Using VBA on Excel Pivot Tables 3
Automatically keeping cells together when printed. 1

Back
Top