Keep borders when list expands
 

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

Keep borders when list expands
 

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

Peter

" wrote:

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

Keep borders when list expands
 

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

wrote:

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

--

Dave Peterson

Keep borders when list expands
 

Nice one Dave!

Peter

"Dave Peterson" wrote:

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

Keep borders when list expands
 

Yeah, that hit the spot, thanks!

On Jun 29, 3:02 pm, Billy Liddel
wrote:
Nice one Dave!

Peter



"Dave Peterson" wrote:
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- Hide quoted text -

- Show quoted text -