SOLVED
Home

Excel: Colored cell border

%3CLINGO-SUB%20id%3D%22lingo-sub-732808%22%20slang%3D%22en-US%22%3EExcel%3A%20Colored%20cell%20border%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732808%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20invoice%20form%20that%20for%20some%20reason%2C%20unknown%20to%20me%2C%20has%20a%20bottom%20cell%20border%20that%20is%20red%20and%20I%20can%20not%20find%20a%20way%20to%20change%20it%20back%20to%20black.%20I'm%20sure%20I%20%22fat%20fingered%22%20something%20at%20some%20point%2C%20but%20I%20can't%20seem%20to%20undo%20it.%20Here's%20a%20screenshot.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121807iC9AE9CF00C9E79D8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Red%20border.JPG%22%20title%3D%22Red%20border.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-732808%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732874%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Colored%20cell%20border%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732874%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F369520%22%20target%3D%22_blank%22%3E%40garyw581%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ESelect%20the%20range%20where%20you%20want%20to%20set%20the%20border%20Color%20and%20%2FOr%20weight.%3CBR%20%2F%3EOpen%20the%20Format%20Cell%20dialog%20box%3CSTRONG%3E%20CTRL%20%2B1%3C%2FSTRONG%3E%3CBR%20%2F%3EClick%20on%20the%20fourth%20tab%20%22%3CSTRONG%3EBorder%3C%2FSTRONG%3E%22%3C%2FP%3E%3CP%3EOn%20this%20Tab%3A%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3Eselect%20the%20border%20Style%3C%2FLI%3E%3CLI%3ESelect%20the%20color%20from%20a%20color%20palette%3C%2FLI%3E%3CLI%3ESpecify%20where%20to%20add%20the%20border%20by%20example%20%2C%20or%3C%2FLI%3E%3CLI%3EClick%20to%20add%20the%20border%20in%20the%20preview%20area%3C%2FLI%3E%3CLI%3EThen%20hit%20ok%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121809iFA1D72EA1606C5A5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Borders.png%22%20title%3D%22Borders.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20remove%20existing%20borders%20you%20can%20select%20%3CSTRONG%3ENone%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732880%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Colored%20cell%20border%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732880%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F369520%22%20target%3D%22_blank%22%3E%40garyw581%3C%2FA%3E%26nbsp%3BFor%20some%20reason%2C%20I%20don't%20see%20a%20border%20in%20your%20screen%20shot.%20Have%20you%20tried%20selecting%20a%20cell%20with%20the%20format%20you%20want%2C%20then%20click%20the%20Format%20Painter%2C%20and%20apply%20it%20to%20the%20cell%20in%20question%3F%20That%20should%20reset%20any%20errant%20settings%20you%20might%20have%20applied.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHTH%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732943%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Colored%20cell%20border%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732943%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWhen%20the%20screenshot%20posted%20the%20red%20color%20of%20the%20line%20went%20to%20a%20grey%20rather%20than%20red...%20I've%20tried%20all%20the%20usual%20ways%20to%20edit%20cell%20borders%20with%20no%20luck.%20There%20is%20a%20small%20black%20mark%20at%20the%20right%20lower%20corner%20of%20the%20group%20of%20affected%20cells.%20It%20looks%20almost%20like%20a%20%22left%20tab%22%20formatting%20mark%20from%20Word.%20I%20have%20no%20idea%20what%20it%20is%20and%20I%20have%20no%20idea%20how%20to%20make%20it%20go%20away.%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121810i6EC4249719AADE7E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Inked%20Red%20border.jpg%22%20title%3D%22Inked%20Red%20border.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732955%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Colored%20cell%20border%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732955%22%20slang%3D%22en-US%22%3EThat%20looks%20like%20the%20Table%20fill%20handle.%20It%20definitely%20looks%20out%20of%20place%2C%20so%20select%20the%20Due%20upon%20cell%2C%20then%20go%20to%20Table%20Design%20%26gt%3B%20Convert%20to%20Range.%20If%20the%20formatting%20still%20applies%2C%20you%20might%20want%20to%20select%20the%20cells%20in%20question%20and%20go%20to%20Home%20%26gt%3B%20Styles%20%26gt%3B%20Normal.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733270%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Colored%20cell%20border%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733270%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20was%20it!%20Once%20I%20converted%20it%20back%20to%20a%20normal%20range%20then%20I%20was%20able%20to%20change%20the%20border%20back%20to%20black.%20Thanks%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733286%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Colored%20cell%20border%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F369520%22%20target%3D%22_blank%22%3E%40garyw581%3C%2FA%3E%26nbsp%3BIt's%20always%20the%20sneaky%20little%20stuff...%20%3B)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
garyw581
New Contributor

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.

Red border.JPG

Any help would be appreciated

6 Replies
Highlighted

@garyw581 

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: 

  1. select the border Style
  2. Select the color from a color palette
  3. Specify where to add the border by example , or
  4. Click to add the border in the preview area
  5. Then hit ok

Borders.png

 

To remove existing borders you can select None

Hope that helps

Nabil Mourad

Highlighted

@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

Highlighted

@Smitty Smith

 

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. 

 

Inked Red border.jpg

Highlighted
Solution
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.
Highlighted

@Smitty Smith 

 

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!

Highlighted

@garyw581 It's always the sneaky little stuff... ;)

Related Conversations
Ribbon or right clicking will not go further out
51218 in Excel on
0 Replies
How to automate a timesheet template?
fishfish31 in Excel on
1 Replies
Excel Worksheets and templates
Christine_R in Excel on
6 Replies
Web links no longer works after data refresh
DataQue in Excel on
0 Replies
Percentage of attendance
linrojy in Excel on
7 Replies
Grouped data visibility in formula builder
Bram_Elfrink in Excel on
1 Replies