How to Copy Border Formatting in Excel to Other Cells

How-to basics · Updated November 20, 2026

To copy borders in Excel, select the source cell, choose Home > Format Painter, then select the destination cell or range. Format Painter copies all cell formatting, not just borders. If you need to preserve the destination’s font, fill, number format, or alignment, apply the border separately using the Borders menu or the Format Cells dialog; Excel’s standard Paste Special options do not offer a borders-only command. The steps below are for Excel for Microsoft 365 on Windows.

What You’ll Need

  • An Excel workbook with a cell or range that has the border you want to reproduce.
  • A clear idea of whether you want to copy all formatting or change only the border. This determines which method to use.
  • For a border with a particular line style or color, note its appearance before applying it to other cells.

Step-by-Step

  1. Choose the right approach. Use Format Painter when it is acceptable to copy the source cell’s other formatting along with its border. Use the Borders menu or Format Cells dialog when the destination’s existing font, fill, alignment, or number format must stay unchanged. Copying a range with Paste Special is useful when you want its full formatting, but it also does not isolate borders.
  2. Select the source cell or range. Click the cell whose border you want to reproduce. If the pattern includes several cells—for example, a thick outline around a group with thin internal lines—select the whole source range instead of just one cell. A single cell will not represent the internal and outside edges of a multi-cell layout.
  3. Copy all formatting with Format Painter, if appropriate. On the ribbon, go to Home > Format Painter. The pointer changes to indicate that the formatting is ready to apply. Click one destination cell, or drag across a destination range. Excel applies the source formatting, including its borders, font, fill, alignment, and number format. It does not copy the source cell’s value or formula.
  4. Use Format Painter for more than one destination. If you want to apply the formatting to several separate areas, double-click Home > Format Painter instead of clicking it once. Select each destination area in turn. Press Esc when you are finished to turn off the painter. A single click turns it off after you apply the format once.
  5. Apply only the border while preserving other formatting. Select the destination cell or range, then open the Borders dropdown at Home > Font > Borders. Choose the matching edge or combination, such as Bottom Border, Outside Borders, or All Borders. If the source uses a non-default line style or color, open More Borders to set those options in the Format Cells dialog before choosing the edges. The names and available choices may vary slightly by ribbon layout.
  6. Match a detailed border in Format Cells. Select the destination and press Ctrl+1 to open Format Cells. Select the Border tab. Choose the line style and color first, then click the diagram edges that should have a border. Use the inside horizontal or vertical controls for internal lines in a selected range, and the outline controls for its perimeter. Click OK to apply the border. This method changes the border without deliberately copying the source cell’s other formatting.
  7. Use Paste Special when all source formatting should transfer. Select and copy the source cell or range with Ctrl+C. Select the destination, then choose Home > Paste > Paste Special > Formats. This applies the source’s cell formats—including borders, fills, fonts, number formats, and alignment—but does not paste its values or formulas. It is not a borders-only option.
  8. Check the result at the destination. Confirm that the border is on the intended edge and that the destination’s other formatting is acceptable. For a multi-cell area, inspect both the outside border and the internal lines. If the result is wrong, use Ctrl+Z immediately, then repeat with the appropriate method or a more accurately selected source range.

On Mac: The ribbon options are similar: use Home > Format Painter, the Borders dropdown, or Home > Paste > Paste Special. In the Format Cells dialog, Command+1 commonly opens the formatting options; if that shortcut is intercepted by your system or keyboard setup, open Format Cells from the ribbon instead. The Windows Ctrl+1 shortcut is not the Mac equivalent. In Excel for the web, use the Home ribbon’s Format Painter and Borders controls; some dialog options and Paste Special choices differ from the desktop app. If a particular border style or color is unavailable in the web interface, open the workbook in desktop Excel.

Common Mistakes

  • Assuming Format Painter copies only borders. It copies the full cell format. For example, painting a border from a currency cell onto a date cell can also change the destination’s number format. Use the Borders controls or Format Cells if you need to keep the destination’s other appearance.
  • Expecting Paste Special to have a borders-only choice. The standard Formats option copies several kinds of formatting together. There is no separate borders-only item in the regular Paste Special dialog, so use the border controls when other formatting must remain intact.
  • Selecting only one cell from a bordered block. A single cell may show only one or two relevant edges, while the original range has a complete outline and internal dividers. Select the full source range when reproducing a layout with multiple cells.
  • Choosing the wrong edge option. All Borders adds lines between cells as well as around the outside. Outside Borders creates a perimeter but does not add internal lines. Bottom Border affects only the bottom edge of each selected cell. Check the preview and choose the command that matches the source.
  • Confusing cell borders with worksheet gridlines. Gridlines are the faint worksheet guides shown behind cells; they are not cell borders. A border is an applied format and can be printed. If a line is visible on screen but not when printed, check whether it is only a gridline.
  • Painting onto merged cells or an uneven selection without checking. Merged cells and ranges with different shapes can make a copied pattern look unexpected. Select a destination with a compatible layout, or apply the needed edges individually with the Borders controls.

Tips

  • Use the painter for speed, not precision editing. It is the quickest choice when the destination should look like the source in every formatting respect. For a border-only change, the Borders menu is safer because it avoids unintentionally replacing other styles.
  • Work on a matching range shape. If a two-row, three-column block has a particular border pattern, select a destination block with the same dimensions before using Format Painter. This makes it easier to reproduce the outline and internal edges consistently.
  • Set color and line weight before drawing edges. In the Format Cells Border tab, choose the line style and color first, then click the edges in the preview. This helps avoid applying a default black line when the source uses a different color or weight.
  • Keep the source visible while matching a complex border. If you must recreate it manually, arrange the source and destination so you can compare them. Check whether the source has a top, bottom, left, or right edge, plus any internal lines, before applying the same combination.
  • Remember that formatting and contents are separate. Format Painter and Paste Special > Formats transfer appearance, not the cell’s text, value, or formula. To duplicate both content and formatting, use ordinary copy and paste instead, then review whether replacing existing destination contents is safe.
  • Consider printing and conditional formatting. Borders are useful for defining sections in a printed worksheet, while gridlines may be controlled separately. Also check for conditional formatting if a cell’s visible appearance changes according to its value; the displayed style may not be explained by the manually applied border alone.

Troubleshooting

The destination’s font or number format changed. This is expected after using Format Painter or Paste Special > Formats, because both transfer more than borders. Undo with Ctrl+Z on Windows or Command+Z on Mac, then apply the border with Home > Font > Borders or Format Cells instead.

The border looks different from the source. Open Format Cells and check the selected line style and color as well as which edges are enabled. Confirm that you used the correct edge command: All Borders, Outside Borders, and Bottom Border produce different results. If the source was a multi-cell block, check its inside lines separately from its outline.

You cannot see the border after applying it. Make sure the correct cells were selected and try a contrasting border color or a heavier line temporarily. A border that matches the cell fill can be hard to see. If the line appears only when you select the cell, inspect whether you are seeing a worksheet gridline rather than an applied border.

The border changes when cell values change. Check Home > Conditional Formatting > Manage Rules and review rules that apply to the cell. Conditional formatting can affect how a cell appears. Adjust the rule or its Applies to range if appropriate; copying a manual border alone may not remove a conditional formatting effect.

The painter keeps applying formatting. If Format Painter was double-clicked, it stays active for multiple destinations. Press Esc to exit. If a wrong format has already been applied, undo it before selecting the correct source and destination again.

The border is missing on a printout. Check that it is an actual cell border and not just a gridline. If you need visible divisions in print, apply borders to the cells, then use File > Print to review the preview. Print settings and page scaling can affect how thin lines appear.

Frequently Asked Questions

Can I copy only a border in Excel without changing other formatting?
Yes, but not with Format Painter or the standard Paste Special > Formats option. Select the destination and apply the required edges through the Borders dropdown or the Border tab in Format Cells. Excel does not provide a standard borders-only Paste Special choice.

Does Format Painter copy cell contents?
No. It copies formatting, such as borders, font, fill, alignment, and number format, but not the cell’s value or formula. To copy contents as well, use normal copy and paste, keeping in mind that this can replace destination data.

Can I copy a border to several separate cells?
Yes. Double-click Format Painter, select each destination cell or range, then press Esc. If the cells need only a border and must retain their other formatting, use the Borders menu to apply the desired edge to a multi-cell selection instead.

What is the difference between Outside Borders and All Borders?
Outside Borders draws around the perimeter of the selected range. All Borders also adds lines between cells inside that range. Choose based on whether the source has internal dividers.

Can Excel copy a border from one worksheet to another?
Yes. Format Painter and the Borders controls can be used between worksheets in the same workbook. With Format Painter, select the source, activate the painter, move to the other sheet, and select the destination. For a border-only change, apply the border options on the destination sheet.

Do these steps work in Excel for the web?
Format Painter and basic Borders commands are available in Excel for the web, although some controls may differ from desktop Excel. For precise border colors or line styles that are not available in the browser, open the workbook in Excel for Microsoft 365 on Windows or Mac.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.