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

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

Hi,

I tried centering across selection also and this does not work.

I am using Excel 2003 if this helps. If you would like I can send you the
spreadsheet.

"Gord Dibben" wrote:

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

Excel does quirky things sometimes.......

Try opening a new workbook and copying your data to it without the
merged cells, type in your first two lines and try again.

It's the equivalent of thumping the TV to bring the picture back lol.

TGHC


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=494715

I've already tried this...no such luck! Thanks though!

"tghcogo" wrote:


Excel does quirky things sometimes.......

Try opening a new workbook and copying your data to it without the
merged cells, type in your first two lines and try again.

It's the equivalent of thumping the TV to bring the picture back lol.

TGHC


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=494715

I've even tried creating a new document with data in just the first few rows.
I still get the same results. I've tried this on a couple of machines running
excel 2003.

"Gladys" wrote:

I've already tried this...no such luck! Thanks though!

"tghcogo" wrote:


Excel does quirky things sometimes.......

Try opening a new workbook and copying your data to it without the
merged cells, type in your first two lines and try again.

It's the equivalent of thumping the TV to bring the picture back lol.

TGHC


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=494715