View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default How can i limit the # of rows printed per page?

File, Page Setup, change your Scaling setting to how you want it to be.

kat wrote:

I have a spreadsheet that is used to keep track of jobs being done at my
company. Users add rows as needed. I have the page borders set but that
causes the text to get smaller and smaller when rows are added. Is there a
way to set a limit for the number of rows printed per page so that once that
limit is reached, the additional rows overflow onto the next page?