G
Guest
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?
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?