Excel 2000 Formatting issue

[gearhead03]

I think it's a formatting issue. I have a file that I use to bill one of my customers. They built the file. Several columns are calculated. They have 459 rows set up. We usually use 35-40 rows. When I print, all 50 pages print. How do I get rid of the extra rows? I have tried to delete them. That deletes the outlines but it still tries to print the blank pages.
I tried clear print area. That didn't work. I am sure it's a formatting issue but I do not know how to undo.

Mark A. Kale

 

[SkipVought]

Hi,

Try using the AutoFilter to HIDE the unused rows before printing.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[gearhead03]

That works very well Skip, Thanks for your help.

We also send this file to a different company. They want us to delete any lines that are not used before sending the file. How do I accomplish that?

Mark A. Kale

 

[SkipVought]

Use the INVERSE criteria in the AutoFilter to display the empty rows. Select the ROWS to remove and DELETE

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}