Hi everyone I'm new to the forum but having an issue that I was wondering if you guys could help me with.

I'm working on a spreadsheet as a favour for a friend at her work. The spreadsheet is a large form she uses to collect customer data on the phone and she has asked me to put this data into another tab in the file which builds a letter that then gets printed out and sent to the customer.

The problem is there is a large section of this letter which only gets added if the customer says they have a specific requirement which on the form sheet is a Yes or No answer (as it concerns legal stuff they have to have if this requirement is true). I have an if formula set up with data validation where if the cell equals Yes to show the text but if it equals No to just be empty "" i.e. =IF(A1="Yes","Display text","").

However when you go to print the letter out the normal hide empty cells doesn't work as obviously the formula is still there so it's technically not empty and instead there are massive white gaps.

I do know you can manually hide the row before you print it but that would be a pain if my friend were doing it 8-10 times a day so I just wondered if there was a setting which can be used to do this each time?

Many thanks in advance!