Hiding Rows in excel.
Budget: $10 – $30 AUD
I have created a sheet that has a formula to automatically filter information from another sheet, which works perfectly, although when I save the filter information as a PDF it also saves 1000 empty rows (Which are set in the print area for progressive works).
If I was to create a normal filter (One not from a formula), the blank rows would automatically be removed and only the populated cells would save. I don't want to do this as I want to full lock the sheet and filtered columns don't lock.
If I was to create a normal filter (One not from a formula), the blank rows would automatically be removed and only the populated cells would save. I don't want to do this as I want to full lock the sheet and filtered columns don't lock.