Forum Discussion
Solved
Excel: Colored cell border
I have an invoice form that for some reason, unknown to me, has a bottom cell border that is red and I can not find a way to change it back to black. I'm sure I "fat fingered" something at some point...
- That looks like the Table fill handle. It definitely looks out of place, so select the Due upon cell, then go to Table Design > Convert to Range. If the formatting still applies, you might want to select the cells in question and go to Home > Styles > Normal.
When the screenshot posted the red color of the line went to a grey rather than red... I've tried all the usual ways to edit cell borders with no luck. There is a small black mark at the right lower corner of the group of affected cells. It looks almost like a "left tab" formatting mark from Word. I have no idea what it is and I have no idea how to make it go away.
That looks like the Table fill handle. It definitely looks out of place, so select the Due upon cell, then go to Table Design > Convert to Range. If the formatting still applies, you might want to select the cells in question and go to Home > Styles > Normal.
That was it! Once I converted it back to a normal range then I was able to change the border back to black. Thanks so much!
garyw581 It's always the sneaky little stuff... ;)