• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Use Format Painter in Excel

August 11, 2021 by Andrew Childress
How to use format painter in Excel

You’ll find yourself wanting to use the very same formats again and again. Excel offers a quick way to do that. Here's how to use Format Painter in Excel.

Cell formats are a good way to add custom styling to your spreadsheets. Often, you’ll find yourself wanting to use the very same formats again and again. Fortunately, Excel offers a quick way to do exactly that, without the need to start from scratch. Let’s learn how to use Format Painter in Microsoft Excel.

How to Use Format Painter in Excel

Imagine that you’re working in a spreadsheet with a list of data values. For one of the cells, you’ve added some custom formatting elements. For example, in cell B2 here, you’ve made the price bold, and changed the text color from black to orange.

Now, you want to apply the identical formatting to a different cell, like cell B6. Of course, you could always apply the color and bold effects manually, just as you did with cell B2. But thanks to the Format Painter feature in Excel, there’s a much easier way to copy the formatting and duplicate it in other cells.

To start using Format Painter, begin by clicking into the cell containing the formatting that you wish to copy. Here, that’s cell B2. Then, find the Home tab. This is located on Excel’s ribbon at the top of your screen.

Format painter in Excel

On the left side, you’ll see a paintbrush icon. This is the Format Painter feature. With your cell selected, click on Format Painter.

Excel will, in essence, copy the formatting from the selected cell. From here, you have two options. To apply the formatting to a single cell, simply click into that cell. Here, we’ll use cell B6. As you can see, Excel will instantly apply the copied formatting to the newly-chosen cell.

Use format painter in Excel

You can also use Format Painter across multiple cells, for example, the range B3:B5. Repeat the earlier steps of selecting B2 and clicking Format Painter. Then, simply drag your cursor across the range. Format Painter will apply the formatting to all three cells.

How to use format painter in Excel

As you can see, Format Painter is a quick and easy way to duplicate cell formats in Excel.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to apply a cell style in ExcelHow to Apply a Cell Style in Excel
Next Post:Create New Formatting Rule in ExcelCreate new formatting rule in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top