keep cell borders when autofiltering

  • Thread starter Thread starter aasher20
  • Start date Start date
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
 
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'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing with cell borders 1
Border and cell content mis-alligned printing 2
Border Problems 2
Borders slowing filter process in Excel 2003 1
COLUMN BORDER ISSUE 2
removing cell pattern 3
Removing Cell Borders 2
Lock Cell Borders 2

Back
Top