Quote:
Originally Posted by juliansdad
Thanks for your effort, Pecoflyer. I've attached a Before (left) and After (right) Shot to illustrate what I'm describing. In the attached examples, When I dragged & dropped cell I-4 (E. Stein) to H-3, the outline border on the right side of I-4 disappeared.
I want to set up this table so that the border outlines don't disappear regardless of which cells I drag and drop. I appreciate any advice that you can offer me.
|
Not sure what version of Excel you have but it's always had problems dragging or cutting, which I'm guessing it's doing in the background when you drag, from the outside of a range of cells with borders to somewhere else.
It seems to get it's right edge formatting from the cell to the right for some odd reason, likewise top and bottom.
One fix, probably not pretty but it works, is to add a column to the left of the table and one to the right and format it like your data cells.
Then dragging from the Left & Right edges doesn't change borders. If you ever drag from the bottom or the top do the same.
See the Attachments. I made Column A & G .42 cm so you can see what I did. Can make it smaller but it plays up with mouse control. Can't hide them either as then Excel ignores the formatting in the hidden column.
Dragging F6 to E7 leaves F6 with a border