Setting up pages in a workbook

  • Thread starter Thread starter calimari
  • Start date Start date
C

calimari

I have just created hundreds of workbook pages with different data. What
I would like to know is how do I set up every page to be in the same
format without having to do each one separately? :eek:

Thanks ahead of time.
 
That helps a lot, except I don't seem to be able to move the page break
(which is in the middle of the pages). How do I fix it so the page brea
is at the end of the sheets?

Thank you ;
 
Answer: It depends....

Generally, though, you could group all pertinent sheets, and set the
print properties (File>Page setup>etc) to print landscape. That might
move the break.

If you have already done that and the page break still is not where you
want it, there may be other issues. One more thing, if the problem is
that the page break is just annoyingly visible, do this:
Tools>Options>View>Uncheck Page Breaks.

Does that help?

Ron
 
Copy page, paste to new page, delete data from new page and re-enter data as
your want. the format will remain the same as the one you copied.
 
Back
Top