How Do You Keep Cell Outline Borders After Dragging & Dropping?

SteveWcg · #4 12-10-2013, 05:21 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dragging conditional formatting like a formula	sjp1966	Excel	9	04-13-2017 06:01 AM
Moving cell content without moving borders & shading?	unittwentyfive	Excel	1	10-25-2013 12:56 PM
Dragging Pictures into Placeholders	simville02	Drawing and Graphics	1	09-29-2013 06:33 PM
Appointments dropping off in outlook 2007	b_rianv	Outlook	0	01-09-2013 02:23 PM
Page-crossing borders in a table with hidden between-cell borders	tenpaiman	Word	2	08-08-2012 07:20 PM