I'm using Excel 2003, and I have 5 columns all on the same sheet. I want each
column to have its own sheet. The page breaks are fine except for in 1 case.
The first page takes up enough rows to go onto page 2. The remaining columns
can all fit on 1 page. So, when you view the page break preview...it looks
like this...

page 1 page 3 page 5 page 7
page 2 page 4 (blank) page 6 (blank) page 8 (blank)

I don't want those blank pages. I want to get rid of page 4, 6, 8.

I can't just delete rows because page 2 has data in those rows. I know this
could be printed manually, but I deal with this every day and would just like
them gone.

Any ideas?

It looks like I over thought this and the answer was as simple as setting the
print area.

"Dan Connors" wrote:

I'm using Excel 2003, and I have 5 columns all on the same sheet. I want each
column to have its own sheet. The page breaks are fine except for in 1 case.
The first page takes up enough rows to go onto page 2. The remaining columns
can all fit on 1 page. So, when you view the page break preview...it looks
like this...

page 1 page 3 page 5 page 7
page 2 page 4 (blank) page 6 (blank) page 8 (blank)

I don't want those blank pages. I want to get rid of page 4, 6, 8.

I can't just delete rows because page 2 has data in those rows. I know this
could be printed manually, but I deal with this every day and would just like
them gone.

Any ideas?