Page breaks for printing

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi,

Does anybody know if there's a way to have Excel
automatically set page breaks whenever there is a change
in the data in, say, columns A or M (I will have the
spreadsheet sorted by A, then M)?

Thanks,
John
 
Not automatically, but you can apply the subtotal functionality in the tools
menu. You have to apply it twice without replacing the second time to work
with two columns.
 
Back
Top