Hello!

I have an Excel spreadsheet that is supposed to be filled in by customers. I
have some columns that will take input and other columns that I have
prefilled with formulas. Now, my problem is that when I go to print this
document, Excel prints every row that has formulas on it, even if the
formulas generate an empty result when there are no customer-input values on
that row. I have prefilled the spreadsheet so the customer can input a few
hundred rows of data if they would have that much data, and this comes out
as several empty (only headers) pages getting printed.

Is there a solution to this problem? I would prefer if it could be somehow
done with a setting on the formula or lines or cell formatting, so the
customers don't get the Excel macro warning when they open the spreadsheet,
if it can be avoided.

Thanks in advance for any help,
Andreas Hansson