Page breaks for printing

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
 
T

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.
 
Top