You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers question - when printing, will numbers hide rows in an invoice if one of the cells does not have a value

. or some other sort of conditional formating. but still how up


MacBook Air is writing the invoice. used on iPhone and iPad using iCloud

MacBook Air (M2, 2023)

Posted on Aug 19, 2023 10:38 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 19, 2023 11:47 AM

Do you mean filling a table with

and printing it like?


No, not directly. What you could do is set a filter that only shows rows where the Quantity column is not empty. You'd have to toggle the filter on before printing and off after to regain view of all item lines.


Now, you might think that it would affect other parts of the invoice. To avoid that, split your invoice in separate tables, one for the header, one for the actual order, and one for the footer, like this. Hide the table names and stick the tables together.

1 reply
Question marked as Top-ranking reply

Aug 19, 2023 11:47 AM in response to foolinprince

Do you mean filling a table with

and printing it like?


No, not directly. What you could do is set a filter that only shows rows where the Quantity column is not empty. You'd have to toggle the filter on before printing and off after to regain view of all item lines.


Now, you might think that it would affect other parts of the invoice. To avoid that, split your invoice in separate tables, one for the header, one for the actual order, and one for the footer, like this. Hide the table names and stick the tables together.

Numbers question - when printing, will numbers hide rows in an invoice if one of the cells does not have a value

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.