keep cell borders when autofiltering

A

aasher20

Hi all,

I have a sheet set up in excel with exactly the borders i need aroun
every cell, so it looks nice when it prints. Is there a way to kee
these borders in place when i autofilter new data around within th
sheet?

thanks in advance.

Austi
 
D

Debra Dalgleish

When you filter the list, the borders should remain the same. To add
items to the list, and maintain the formatting, check that there's a
check mark in Tools>Options, Edit tab, 'Extend list formats and formulas'
 
Top