Page breaks for printing

[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

 

[Tom Ogilvy]

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.