Jul 01 2019 12:36 PM
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, but I can't seem to undo it. Here's a screenshot.
Any help would be appreciated
Jul 01 2019 01:13 PM
Hi,
Select the range where you want to set the border Color and /Or weight.
Open the Format Cell dialog box CTRL +1
Click on the fourth tab "Border"
On this Tab:
To remove existing borders you can select None
Hope that helps
Nabil Mourad
Jul 01 2019 01:14 PM
@garyw581 For some reason, I don't see a border in your screen shot. Have you tried selecting a cell with the format you want, then click the Format Painter, and apply it to the cell in question? That should reset any errant settings you might have applied.
HTH
Jul 01 2019 01:34 PM
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.
Jul 01 2019 01:43 PM
SolutionJul 01 2019 02:36 PM
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!
Jul 01 2019 02:53 PM
@garyw581 It's always the sneaky little stuff... ;)
Jul 01 2019 01:43 PM
Solution