How to use Format Painter in Excel

Search
Generic filters

Table of Contents

Where’s the Format Painter Button?

It’s there on your Home Tab. If you look at the clipboard section (Left Side) of your Home Tab, you can find it.

 

How Format Painter works?

  1. When you select a cell or range and click on the format painter button it copies formatting.
  2. After that, when you select another cell or range it pastes formatting there.

How to use Format Painter

As I said, it’s a one-click process.

 
  1. First of all, select the range or cell from where you want to copy the formatting.
  2. After that, click on the format painter button.
  3. Once you click on the button, your cursor will convert into a paintbrush.
  4. Now, select the range on which you want to apply formatting.

It’s done.

Can I use Keyboard Shortcut?

Yes, you can use the Alt + H + F +P for format painter. Just select the range or cell from which you want to copy format and use the shortcut key.

Apply Formatting Multiple Times

Yes, you can use it to paste formatting multiple times.

 

  1. First of all, select the range from where you want to copy formatting.
  2. After that go to Home Tab → Clipboard → Format Painter.
  3. Now, double-click on the format painter button.
  4. From here, you can paste the formatting multiple times.

Bonus Tip: Copy Column Width using Format Painter

 

  1. First of all, select the entire column from where you want to copy column width.
  2. After that, click on the format painter button.
  3. Click on the column header of the destination column.

Free Excel Templates

Weekly_Planner_V1.4

Weekly Planner

Following the trend of daily planner template, I created weekly …

Download Now
Simple-Profit-and-Loss-Self-Employed-Statement-Overview

Simple Profit and Loss Statement

If you’re self-employed, preparing a Profit and Loss statement may …

Download Now
Swot analysis

Swot analysis

A SWOT Analysis is a structured brainstorming and evaluation tool used to …

Download Now
christmas-gift-budget.xlsx

Christmas Budget

Free Christmas Budget Spreadsheet template This is Free Christmas Budget …

Download Now

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.