Gladys

Although I cannot replicate the problem using your description.........

Try un-merging the cells in A:J and use the "Center across selection" method
instead.

Can be found at FormatCellsAlignmentHorizontal.

Merged cells cause no end of problems with many Excel functions/features.


Gord Dibben Excel MVP

On Mon, 19 Dec 2005 13:26:03 -0800, Gladys
wrote:

My Spreadsheet first 2 rows has data in columns A - which is merged through
Column J for centering purposes - That is the only thing on Rows 1 and 2

The spread sheet goes through column AD

When I setup page to have first two rows repeat at the top - it does not
work. The data is only printed on page 1

Any suggestions