The issue you have is that the border across the bottom is a bottom border on
your last populated row. Change it to a top border on your first blank row
and it will remain even if the bottom row is hidden.
--
HTH...

Jim Thomlinson


"Teddy-B" wrote:

I have a spreadsheet that has nice black borders all the way around. When I
filter the sheet for printing to leave out blank cells (some blanks at the
bottom) part of the border disappears (at the bottom). How do I filter the
sheet and retain my borders?

Thanks for your expert help.