Thread: Auto Page Break
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChuckF
 
Posts: n/a
Default Auto Page Break

I am sure this isn't the "right" way to do it, but I think it should
work.

I just created a long spreadsheet, went into Page Break View, and moved
the first dotted horizonal line to line 85.

I then scrolled down, and now the break is on every 85th row (85, 170,
255, 340, ect ext)

Anyway...hope this helps.