Re: excel bordeers
- From: Anna K Byrne <annakb@xxxxxxxxxxxxx>
- To: jfw@xxxxxxxxxxxxx
- Date: Tue, 09 Mar 2004 19:05:06 -0600
I'm still struggling with this one, but with Excel 2000 and up I believe
borders work like this.
Under format cells, borders, first select the border you want (thin
continuous....), then choose either 'preset none' or 'preset outline.' If
preset none, check the boxes after the preset buttons--top, left edge,
bottom, right edge--as you would like them, hit enter on the border style
again (thin continuous), then press okay. If you choose 'preset outline',
go directly to okay--do not collect 200 dollars.
Selecting cel a1 and putting a thick continuous border, press alt-shift-b
and JFW should say 'surrounding border of active cell, thick
continuous.' This is cool, and what I would have expected. When you start
merging cells, though, things get more complex. Putting a thick continuous
border around merged cells a1:f1, jfw says 'left edge thick continuous, top
thick continuous, right edge thin grid line, lbottom thick
continuous.' Moving to the adjacent cell, g1, JFW says 'left edge thick
continuous, top thin grid line, right edge thin grid line, bottom thin grid
line.'
If you separate the cells, JFW reports that a1 has thick continuous left
edge, top and bottom, and thin grid line right edge; that cells b1 through
e1 have thick continuous top and bottom, and thin grid line right edge and
left edge; and that f1 has thick continuous top, right edge, bottom, and
thin grid line left edge.
The default is thin grid line, right? So JFW does not report the
surrounding border of merged cells correctly unless you unmerge
them. However, Excel does appear to be doing what it says it's going to do.
And that and a buck will get you a cup of coffee.
--
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
