To edit a cell border color in Excel for Microsoft 365 on Windows, select the cells, open Home > Borders ▼, choose Line Color, and pick a color. Then open the Borders menu again and apply the border edge or preset you want. For precise control over existing edges, use the Border tab in the Format Cells dialog. You will need a workbook and cells where you want visible borders; selecting cells alone does not create a border.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows, or a version with the Borders controls.
- A workbook with the cells you want to format. Save a copy first if you are changing a complex layout.
- The desired color, such as a standard palette color or a specific brand color if your Excel version provides custom colors.
Step-by-Step
- Select the cells or range. Click one cell to format it, or drag across a range to format several cells together. To select an entire table area, include the cells along its outside edge as well as any interior cells that need borders. If you want to edit one side of a cell, select the cell or cells whose edge you intend to change. For nonadjacent ranges, hold Ctrl while selecting additional ranges on Windows; formatting can be less predictable when the selections have different existing borders, so check each area afterward.
- Open the Borders menu. On the ribbon, select Home. In the Font group, click the small arrow beside the Borders icon, not the main part of the icon. The main icon repeats the last-used border command, while its arrow opens the choices. If the ribbon is compressed, widen the Excel window or expand the Font group to find the arrow.
- Choose a border color. In the menu, point to or select Line Color, then choose a color from the palette. Avoid choosing a font color or fill color: those change the text or cell background, not the border. If the palette offers More Colors, use it to enter a custom color when available. The selected line color is used when you apply a border; choosing a color by itself may not recolor any existing edge.
- Apply the border edge or preset. Open the Borders menu again and select the border you want, such as Outside Borders, All Borders, or Bottom Border. The command applies the chosen line color to the edges it draws. For example, to make a colored outline around a block without adding lines between its cells, select the whole block, choose a line color, and apply Outside Borders. To color every cell division in a selected range, choose All Borders instead.
- Check whether the correct edges changed. Click away from the selection and inspect the result at a normal zoom level. If the color is correct but the wrong edges appeared, undo with Ctrl+Z on Windows and repeat the border command with the correct selection. Some presets replace the border configuration for the selected edges, so use the command that matches the layout rather than clicking several presets at random.
- Use Format Cells for precise edits. Select the relevant cells and press Ctrl+1 to open Format Cells. Choose the Border tab. Under Color, pick the new line color; optionally choose a line style first. In the preview area, click each edge you want to add or change: the top, bottom, left, right, or interior lines. Click an edge again if needed to remove it. The preview helps distinguish an outline from internal grid lines. Select OK when it shows the intended result.
- Recolor only existing edges in the dialog. In the Border tab, selecting a color does not necessarily change every edge already shown in the preview. Click the specific preview edges using the new color so Excel redraws them, and leave other edges alone. If the selection contains several cells with different borders, the preview can represent a mixed state; carefully set each required edge rather than assuming one click has standardized the entire range.
- Repeat the format where needed. For another range, select it and apply the appropriate border command. If you want to reuse a completed cell’s appearance, copy that cell and use Home > Paste ▼ > Paste Special > Formats where available, or use Format Painter. These methods copy other formatting too, so inspect the destination for unintended font, fill, or number-format changes.
Mac and web notes: In Excel for Mac, the Borders controls are on Home; choose the dropdown beside the Borders button and look for line-color and border options. The shortcut to open Format Cells is Command+1 rather than Ctrl+1. Excel for the web has a more compact ribbon, and options can differ by account or interface version. Use its Home tab Borders dropdown if it offers the color you need; for the full desktop Border tab or more detailed customization, open the workbook in Excel for Windows or Mac.
Common Mistakes
- Choosing a color but not applying a border. The line color setting is not itself an edge command. After choosing a color, apply the relevant border preset, or click the intended edges in Format Cells.
- Using the wrong color control. Font Color changes characters; Fill Color changes the cell background. Use the Borders dropdown’s Line Color option or the Border tab’s Color palette.
- Applying All Borders when only an outline was wanted. All Borders adds internal lines throughout the selected range. For a simple frame around a range, choose Outside Borders.
- Selecting the wrong range. A border command affects the current selection. If the range includes neighboring cells, the new lines can make the table look crowded or alter edges you meant to keep.
- Expecting gridlines to change color. Worksheet gridlines are not cell borders. Border formatting affects only explicit borders and can print; gridlines are display aids and have separate settings.
- Assuming a new color updates every old edge automatically. In the Format Cells dialog, explicitly click the edges to redraw. In the ribbon, choose a border command that reapplies the intended edges.
Tips
- Use a restrained palette. Dark gray or a theme accent often remains readable on screen and in print. Reserve bright colors for emphasis, and keep table headers and data rows consistent.
- Match the border style to its purpose. A heavier outside line can frame a section, while thin interior lines keep a table legible. Choose the line style in Format Cells before clicking the preview edges.
- Format related ranges together when practical. Applying a border to one complete rectangular range can be quicker and more consistent than formatting each cell separately. If some edges need different colors or weights, use smaller selections or the Border tab.
- Zoom in to inspect thin lines. Very light colors and thin strokes can be difficult to see at low zoom. Check the worksheet at a useful viewing size and use Print Preview if the result needs to print clearly.
- Use theme colors for documents that may be restyled. Theme colors can adapt when the workbook theme changes. A custom color is useful for an exact match, but it may not follow later theme changes.
- Keep a clean original for elaborate formatting. If the range has many different edge styles, duplicate the sheet or save a copy before making broad changes. This makes it easier to compare the original if the result is not right.
Troubleshooting
The border still looks black. Confirm that you chose Line Color, not Font Color, and then applied a border. In Format Cells, check the Border tab’s preview and make sure you clicked the edges after selecting the new color. If a thick or dark line remains, select that edge again with the intended color and style.
No border appears after choosing a color. Select the cells again and apply a border preset, such as Bottom Border, or add an edge in the Format Cells preview. A color selection alone may only set the color for the next border you draw.
Only some cells changed. Check the selection outline and make sure the full intended range was selected before formatting. When cells have mixed border formatting, undo the change if necessary, select a smaller group with consistent formatting, and apply the new edges separately.
The color is hard to see. A pale line can blend into the worksheet, especially on a white background. Try a darker palette color, a thicker line style, or a higher zoom level. Also confirm you are looking at actual cell borders rather than faint worksheet gridlines.
The Borders or Line Color option is missing. Expand the ribbon, check the arrow beside the Borders icon, and confirm you are in Excel rather than a viewer with limited formatting. Excel for the web and mobile interfaces may offer fewer choices. Open the file in desktop Excel if the full color palette or Format Cells Border tab is unavailable.
Formatting changed more than the border. If you used Paste Special or Format Painter, those tools may have copied additional formatting. Undo, then use the Borders controls or Format Cells to change only border edges.
Frequently Asked Questions
Can I change the color of a border that is already there?
Yes. Select the cells and reapply the required edges using a new Line Color, or open Format Cells with Ctrl+1, choose Border, and click the existing edges in the preview with the new color selected.
How do I change just the bottom border color?
Select the cell or range, choose a color under Home > Borders > Line Color, then apply Bottom Border. In Format Cells, select the color and click only the bottom edge in the preview.
Can I use an exact custom color?
In desktop Excel, open the border color palette and choose More Colors if that option is shown. Enter or select the custom color in the dialog, then apply the border. The available custom-color controls can differ by platform and version.
Will changing a border color affect the cell contents?
No. Border formatting changes the cell edges, not the value, formula, font, or fill. Be sure you are using the border color control rather than the adjacent font or fill controls.
Do colored borders print?
Explicit cell borders generally print with the worksheet, subject to printer and print settings. Gridlines are separate and may be omitted unless enabled for printing. Use File > Print to check the preview before printing.
Can I remove a colored border instead?
Select the cells, open the Borders dropdown, and choose No Border to remove borders from the selection. In Format Cells, click the active edges in the Border preview to turn them off, then select OK.
Related
- Excel AutoSave: How to Turn It Off and Keep Changes Safe
- Delete a Protected Sheet in Excel: Steps and Fixes
- How to Delete Only Visible Rows in Excel Without Hidden Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Header in a Word TableTo add a header in a Word table, put descriptive labels in the top row, then select the…
- Circular References in Excel: How to Find and Trace ThemTo view a circular reference in Excel for Microsoft 365 on Windows, open the workbook and select Formulas…
- Double Space in Word: Easy Steps for Desktop and WebTo double-space text in Microsoft Word, select it and choose Home > Line and Paragraph Spacing > 2.0.…
- Excel Sum by Cell Color: Methods That Actually WorkExcel does not have a built-in SUMIF function that adds cells based on fill color. To total one…
- Excel Data Analysis ToolPak: Setup and Uses“Excel data analysis pack” usually means the Analysis ToolPak, a Microsoft Excel add-in for statistical and engineering calculations.…
- Average Hours and Minutes in Excel: A Step-by-Step GuideTo average durations in Excel, enter them as time values, use the AVERAGE function, and format the result…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.