Re: excel bordeers
- From: "MFurn" <midnight1@xxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 13:31:37 -0500
Hi Anna.
You did a marvellous job in describing a lot of what happens with borders.
Could you please tell me how does the "inside button" work?
Let us use the range a1to f10 as an example. A thick border has been
assigned and works well. Now, as you stated, all inside borders are thin
line graphic. Try as I might, I can not change the inside lines with out
changing the outside borders. Even If a smaller range is picked. For
example, c2 to e9.
I did find out, if you chose, for sake of arquement, thick continue line for
a1 to f10, then chose a1 to a10 and go to the border tab, the left, top and
right border will be checked. Therefore, all you have to do is check the
bottom and all outside borders are thick continue.
Now, what I wish to do is have the bottom border medium continue. No matter
if I select a2 to f2 and chose medium contine for the top, the left outside
in a2 and the right for f2 become thin graphic. In other words, I'm
overriding the first setting fo thick continue for the outside border.
Confused? So am I!!!
Have a coffee and an asprine.
Mark F.
----- Original Message -----
From: "Anna K Byrne" <annakb@xxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Tuesday, March 09, 2004 8:05 PM
Subject: Re: excel bordeers
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
--
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:
