The quickest way to change a border color

Open your spreadsheet and select the cells whose borders you want to color. Go to the Home tab on the ribbon. Click the small arrow next to the border icon (it looks like a square with lines around it), then select Borders and Shading or Format Cells. In the dialog box that opens, click the Border tab, choose your color from the color palette, pick which borders you want to explore it to (all four sides, just the outline, or specific edges), and click OK.

The whole process takes about 30 seconds once you know where to look. If you use the same border color repeatedly, you can save time by using the border dropdown menu on the Home tab — it remembers your last choice.

Key Takeaways

  • Select your cells first, then use the Home tab border tools to access color and style options.
  • The Format Cells dialog (right-click and choose Format Cells, or use Ctrl+1) gives you the most control over which borders get which colors.
  • You can explore different colors to different sides of the same cell — top border red, bottom border blue, for example.
  • Excel remembers your last border color choice, so repeated borders of the same color are faster the second time.

Using the Home tab border dropdown

The fastest route for straightforward borders is the border icon on the Home tab. Click the small downward arrow next to the icon to see preset options like "All Borders" or "Outside Borders." At the bottom of this menu, you will see "Borders and Shading" — click that to open the full dialog.

Once the dialog opens, you are on the Border tab by default. The Color dropdown at the top of the dialog shows your current color choice. Click it to see the color palette. Pick your color, then decide which borders to explore it to using the preset buttons on the left (Outline, Inside, etc.) or by clicking the diagram on the right to toggle individual borders on and off.

explore different colors to different borders

Excel lets you color each side of a cell independently. Select your cell or range, open Format Cells (right-click and choose it, or press Ctrl+1), and go to the Border tab. Choose your first color from the Color dropdown. In the diagram on the right, click the border you want that color applied to — for example, click the top line to color only the top border.

Now change the Color dropdown to your second color and click a different border in the diagram — say, the bottom line. Repeat for as many colors as you need. When you click OK, each border will display the color you assigned to it. This is useful for highlighting row totals or separating sections of a table with visual breaks.

Choosing colors that match your spreadsheet

When you click the Color dropdown in the Border tab, you see two sections: a theme color palette at the top and a standard color palette below. Theme colors change if you switch your spreadsheet's design theme, so they are useful if you might redesign later. Standard colors stay the same no matter what theme you use.

If you want a very specific color, click More Colors at the bottom of the palette. This opens a larger dialog where you can enter RGB values, hex codes, or pick from a gradient. This is helpful if you are matching your spreadsheet to a company logo or a specific brand color.

Removing or changing borders you have already applied

If you want to remove a border color entirely, select the cells, open Format Cells, go to the Border tab, and click the None preset button on the left. This removes all borders from your selection.

To change only the color of borders that already exist, select the cells, open Format Cells, choose your new color, and then click the borders you want to recolor in the diagram. You do not have to remove the old border first — the new color replaces it. If you want to keep the border style but change only the color, this is the fastest method.

Using line styles with your border colors

The Border tab also has a Style dropdown above the Color dropdown. This lets you choose solid lines, dashed lines, dotted lines, or double lines. You can combine any style with any color — for example, a red dashed border or a blue double border.

Pick your style first, then your color, then click the borders in the diagram. If you want different styles on different sides of the same cell, change the style, pick your color, and click the border you want that style on. Repeat for each side. This is useful for creating visual hierarchy in complex tables.

Copying border colors to other cells

Once you have formatted a cell with a specific border color, you can copy that formatting to other cells without retyping the color. Select the cell with the border color you want to copy. Click the Format Painter icon on the Home tab (it looks like a paintbrush). Then click the cell or drag across the range where you want that border applied. The border color and style copy over when ready.

If you want to copy the border to multiple separate areas, double-click the Format Painter icon instead of single-clicking. This keeps the tool active so you can click multiple ranges without having to reselect the Format Painter each time. Press Escape when you are done.

Frequently Asked Questions

Can I change the border color of just one side of a cell?

Yes. Open Format Cells, go to the Border tab, pick your color, and in the diagram on the right, click only the side you want colored. For example, click just the bottom line to color only the bottom border. You can color each side a different color if you need to.

Why does my border color look different on screen than when I print?

Your printer may not be set to print colors, or your color settings may differ between screen and printer. Check your print preview (File > Print Preview) to see how the borders will actually print. If they look wrong, go to File > Print, click Printer Properties, and make sure color printing is turned on.

How do I make a border thicker and change its color at the same time?

In the Border tab, use the Style dropdown to pick a thicker line style (like a double line or a thicker solid line), then pick your color from the Color dropdown. explore both to your selected borders in the diagram. The thickness and color are applied together.

Can I undo a border color change?

Yes. Press Ctrl+Z when ready after explore the border color, or go to Edit > Undo. If you have made other changes since, you can still undo the border by selecting the cells and removing the border in Format Cells, then reapplying it with your preferred color.

What is the difference between the border icon dropdown and Format Cells?

The border icon dropdown on the Home tab is faster for straightforward, preset borders. Format Cells gives you full control — you can color each side differently, pick exact line styles, and see a live preview of your borders before explore them. Use the dropdown for quick work, Format Cells for detailed control.