Inserting Page Breaks

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

Guest

I have a spreadsheet that has subtotals at various rows. I want to insert a page break after each subtotal. I have tried using only visiable cells but this inserts the page break above the subtotals. Any suggestions

Thanks.
 
Well, this depends. If you are using Excel's Data|Subtotal feature (in the Data menu), you can choose to page break before groups and let Excel do this for you. The information will need to be Sorted by column headings for this feature to work smoothly
You could also switch to the Page Break Preview by choosing View|Page Break Preview. Then, you can right-click on the spreadsheet and choose Insert Page Break wherever you want. (Note: make sure you choose Insert Page Break, not Insert)

tj
 
If you used Data|subtotals, then there was an option to place each group on its
own sheet (Pagebreak between Groups).

If you're not using Data|subtotals, you may want to look into it.
 
Back
Top