Excel Printing

[theTIK]

I set up a formula and pasted in it to an entire column Sofor every row it calculates it for the cell of that column. But now it wants to print just a ton of blank pages after the first pages which is the only page with data for the time being. I can set the print area everytime I print but is there are way to perminately have the print area igore that column as active cells so it will just print the pages i want automatically?


P.S. I have Office XP

 

[pbj75]

How are you setting the print area? You should set it under File->Print Area->Set Print Area. That makes the print area definition part of the Excel file which means it is saved with the file.

If you just use the print area in the page setup dialog, the settings don't get saved when you quit Excel.