MS Excel in Bangla > Getting started

What is Format Painter and How to work with it

17.3k

Format Painter is a very useful feature in MS Excel. You can use it for applying formatting to cells, for instance, when you need to change all the cells with numbers into currency symbols. Format Painter can also be used when you need to apply the same style of borders around all the cells in a column or row.

  • Choose the text or image with the formatting you wish to copy.
  • Select Format Painter from the Home tab.
  • To apply the formatting, paint over a selection of text or visuals with the brush.
  • Press ESC to halt the formatting.

Format Painter can be installed by downloading it from the Microsoft Office website. Once installed, you can access Format Painter by clicking on “Home” tab and then clicking on “Format Painter”.

Let's take a look at how the format painter shortcut works in Excel: Select the cells or rows that hold the required format, or those from which we want to copy and paste the formatting. Then, on the keyboard, press the Alt, H, F, and P keys.

The benefits of Format Painter are:

  • It is a quick way to copy formatting.
  • It can be used for any type of object, not just text.
  • You can paste the formatting onto any other object.
  • It saves you time and effort by copying formatting from one object to another.

Learner's Ratings

4.7

Overall Rating

  • 83%
  • 10%
  • 4%
  • 3%
  • 0%

Reviews

P
pritam chakraborty
5

very good

S
Sudip Sadhukhan
5

Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you

S
sadananda basak
5

Teaching technique is easy to understand. Thanks.

J
Joydeep
5

nice

U
Uttam Nandi
5

Very nice teaching.

R
RABIN DEY
5

REALLY HELPFUL COURSE

S
Subhasis Bosu
5

good

A
Anamul Huq
5

This is helpful how are zero to intermediate level.

S
Souvik Dutta
4

very good course

R
Raj
5

zero to hero course excel

Show More
Course Content

  1. How to Work with Menu Bar
    5m 39s
  2. How to use LearnVern
    3m 20s
  3. What is Quick Access Toolbar and How to Work with it
    6m 33s
  4. How to Work with Formula Bar
    2m 35s
  5. What is Status Bar and How to Work With it
    5m 33s
  6. How to Navigate within Sheet and Workbook
    3m
  7. How to use Shortcuts
    4m 3s
  8. What is Format Painter and How to work with it
    2m 25s

  1. How to Enter Data in MS Excel
    4m 58s
  2. How to Use Autofill Functionality
    5m 32s
  3. How to Enter Date-Time
    6m 11s
  4. How to Use Undo-Redo
    5m 17s
  5. How to Work With Comments in MS Excel
    3m 29s
  6. How to Save Workbook in MS Excel
    4m 16s

  1. How to Create Formula in MS Excel
    7m 40s
  2. How to Copy Formula in MS Excel
    3m 31s
  3. How to Use Till Date Profit Formula
    3m 37s
  4. How to Work with Percentage Change Calculation
    5m 22s
  5. How to Use Absolute Value
    6m
  6. How to Use Sum Average
    5m 28s
  7. Which are the Common Functions
    7m 39s

  1. How to Format the Fonts
    3m 41s
  2. How to Adjust Rows and Columns
    3m 57s
  3. How to Use Alignment
    7m 3s
  4. How to Format the Borders
    2m 56s
  5. How to Format Numbers
    3m 52s
  6. How to Format Date-Time
    9m
  7. How to Use Conditional Formatting
    9m 6s
  8. How to Format Tables
    9m 1s
  9. How to Format Shapes
    6m 49s

  1. How to Resize Row & Column
    7m 2s
  2. How to Hide-Unhide Row & Column
    5m 23s
  3. How to Copy ,Move & Insert Data
    5m 28s
  4. How to Find and Replace Data
    6m 32s

  1. How to Print
    8m 33s
  2. What is Page Break Preview & How to Set Page
    5m 21s
  3. How to Set Page
    4m 57s

  1. How to create Charts
    7m 10s
  2. Which are the different types of Chart
    5m 37s
  3. How to Format Charts
    6m 31s
  4. Which are the Chart Elements
    7m 42s
  5. How to Use Spark lines
    7m 54s

  1. How to Freeze-Unfreeze the Row & Column
    7m 26s
  2. How to Split the Sheet
    6m 50s
  3. How to Use Outline
    6m 59s

  1. How to Manage Multiple Workbook
    6m 37s
  2. How to Use Rename Insert hide unhide sheets
    4m 38s
  3. How to Copy & Delete Sheets
    6m 30s
  4. How to Use Formula
    9m 4s
  5. How to Edit Links
    9m 12s

  1. What is IF Condition and How to Use it
    6m 25s
  2. What is VLOOKUP and How to Use It
    5m 59s
  3. What is VLOOKUP Exact
    4m 9s
  4. How to Use COUNT IF
    4m 23s

  1. How to Protect Sheet
    4m 52s
  2. How to Secure Workbook
    6m 7s
  3. How to Set Password in Workbook
    2m 19s
  4. How to Share Workbook
    3m 9s
  5. How to Track Changes
    5m 34s

  1. How to Perform Sorting
    6m 35s
  2. How to do Subtotals
    7m 26s
  3. How to Perform Filter
    5m 31s
  4. How to Spilt Data
    4m 20s
  5. How to Use Flash Fill
    3m 35s
  6. How to Remove Duplicate Data
    2m 34s
  7. How to Validate Data
    6m 51s

  1. How to Create Pivot Table in MS Excel
    11m 6s
  2. How to Manipulate Pivot Table
    8m 19s
  3. How to Add Slicers
    4m 36s
  4. How to Perform Grouping of Pivot Table
    4m 39s

  1. What is Macro And How to Use It
    7m 25s

  1. Assignment Q-1
    1m 10s
  2. Assignment Q-2
    21s
  3. Assignment Q-3
    34s
  4. Assignment Q-4
    50s
  5. Assignment Q-5
    48s
  6. Assignment Q-6
    37s
  7. Assignment Q-7
    47s
  8. Assignment Q-8
    45s
  9. Assignment Q-9
    37s
  10. Assignment Q-10
    32s
Enroll For Free