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
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

@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

@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

@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

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.

@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!

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