How Do You Keep Cell Outline Borders After Dragging & Dropping?
I use Excel to view a "snapshot" of my business. Each column has a heading that describes the sequence of the sales process that my clients are in. For example, before I call the client for the first time, his/her name is in a cell beneath the column heading "To Call". After I've called the person, I'll drag and drop his/her cell to another column "prepare proposal," and so on.
If I drag and drop a cell that was in one of the columns furthest on the left or furthest on the right of my table to another column, the outside border that wasn't touching another cell disappears. So if for example, I drag & drop a cell that was in column A to another location on the sheet, the left-side vertical border outline disappears on the spreadsheet. It's simple to go back to the cell that I dragged the data from, format it and reinsert the outer outlineborder to the table. But it's also extra steps that I hope are avoidable.
How can I drag & drop cells on from the columns of my table that are furthest to the left or right to another location and save the outside outline borders of the table at the same time?
|