Keep borders when list expands

V

vilmosius

Hi!

I have a list that needs a set of borders. Thin lines inside, and some
thicker vertical delimiters. Is there a way to make Excel add the
borders when I add rows in my list? I'd like to keep my list neat on
paper. It's a pretty long list (or it will be as it fills up), and
many different users, so an automated process is much preferred.

- Atle
 
B

Billy Liddel

You would need a worksheet_change() macro to do this. Post if this is accepable

Peter
 
D

Dave Peterson

xl2003 added a Data|List feature that looks like it would work the way you want.

You may want to try:
Tools|Options|Edit tab|Extend data range formats and formulas
 
Top