When I copy down rows in an Excel table, why aren't all the formats copied with them ?
Posted on 2012-04-04
When I copy down rows in an Excel 2010 table by dragging the handle in the bottom right cell of the table, it doesn't paste all the formatting of the copied row.
I've attached an example of this. When I drag the handle down on the table's bottom-most row, I'm expecting the copied rows to show the same border formatting. But they don't ! The first two cells lack the bottom border.
Any ideas ?