moving page breaks
 

I am trying to move my page breaks when I have grouped worksheets. I have
done this before but can't figure out why sometimes it works and sometimes it
doesn't. I think there must be some kind of setting that i need to
select...possibly. I select my pages (group), click view, page break
preview and then I would like to just move the page breaks where I need them
so that all the sheets are the same without haveing to do each one
separately. Can anyone tell me what I need to do to make this work? Any
help is greatly appreciated.

moving page breaks
 

There are the manual page breaks that you set yourself and there
are the automatic page breaks that will occur if needed.

I'm taking it that it did not work in Page Break Preview, so I'd
guess you need to do it more manually using Insert (menu), Page Break

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Shelia" wrote in message ...
I am trying to move my page breaks when I have grouped worksheets. I have
done this before but can't figure out why sometimes it works and sometimes it
doesn't. I think there must be some kind of setting that i need to
select...possibly. I select my pages (group), click view, page break
preview and then I would like to just move the page breaks where I need them
so that all the sheets are the same without haveing to do each one
separately. Can anyone tell me what I need to do to make this work? Any
help is greatly appreciated.