View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MrReeLady MrReeLady is offline
external usenet poster
 
Posts: 10
Default Repeating formating from one sheet to another

How do I have excel automatically repeat the borders of all rows to a new
page. I know how to set up to have it repeat my first row with the titles of
each column and I am assuming that when I go into page setup/sheet that I can
choose "Rows to repeat at top" to include the whole page, but I'm not sure
how.

I've created a monthly log and I don't want to create new pages with
copy/paste... if my data exceeds one page, then I would like my page
formatting to automatically display on the new second page and so on...