how to hide and unhide empty rows using slicer

[tshepolt]

Good day

Could you please assist me on this matter, I need to hide and unhide empty rows using a slicer on the attached file

If the slicer can look at column F where I've highlighted in yellow to hide and unhide empty rows in that yellow range please

[tshepolt]

Please anyone can you help

[JeteMc]

Once the column 5 slicer is inserted:
1. To hide the blanks select the first value in the slicer (R 15.00), scroll down to Total and then press the Shift key while selecting Total.
2. To unhide select the clear filter button in the top right corner of the slicer.
Let us know if you have any questions.