Dynamic Print Area that ignores blank cells containing formulas

You can just filter to not show the null values using text filters on column A - then only the "filled" range of the print area will actually print.

Example (2).xlsm

Just filter on the part of your sheet that has the table with the formula....as shown in the attached.

I have a similar issue.
Maybe I'm doing something wrong but here's what I'm trying to achieve. I have a table where each row represents an order number and each column represents a commodity. Each line being printed onto a separate paycheck. Obviously no clients have one of each commodity, they all usually just pick one or two. So I'd like it to skip blank cells when printing. Am I getting previous advice wrong or do I need a different approach?

That's quite an old thread so I'll add that i'm using Office 2013.

You need a different approach, since Excel cannot filter across rows to hide blanks. You could use formulas to extract non-blanks cells, or a macro to hide the columns with blanks values. It all depends on what exactly your work method is.

If you copy your range and paste special / transpose, then you can use autofilters to hide blanks values in the column, but only on a column by column basis. Otherwise, if you post a small sample of what you have, and what you want, then someone can propose a formula or macro solution. But post it as a new question - I'm probably the only person looking at this thread becasue I had subscribed to it - if I had not, I never would have seen your post.