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.

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.

hi
tell us more about the "nice black border all the way around"? how was it
achieved?

regards
FSt1

"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.