Hello,

I printed a spread sheet - it came out to 40 pages, but only 20 of the
40 pages had data.

How do I set Excel to only print rows and columns with data - not the
empty cells?

I just hit the print button and it did it all.

Thanks,

Tmuld.

Either set the print area or delete (not clear-DELETE) the un-needed rows
and SAVE. Try again.

--
Don Guillett
SalesAid Software

"Tavish Muldoon" wrote in message
om...
Hello,

I printed a spread sheet - it came out to 40 pages, but only 20 of the
40 pages had data.

How do I set Excel to only print rows and columns with data - not the
empty cells?

I just hit the print button and it did it all.

Thanks,

Tmuld.

Tmuld

Always a good idea to set your Print Range, Margins and Scaling.

FileSet Print Area

FilePage SetupPage and Margins tabs.

If your "empty cells" are complete rows, you can hide these or filter them out
before printing

Gord Dibben Excel MVP

On 26 Nov 2004 13:34:51 -0800, (Tavish Muldoon) wrote:

Hello,

I printed a spread sheet - it came out to 40 pages, but only 20 of the
40 pages had data.

How do I set Excel to only print rows and columns with data - not the
empty cells?

I just hit the print button and it did it all.

Thanks,

Tmuld.