PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO USE PAINT FORMAT IN GOOGLE SHEETS

INTRODUCTION

PAINT FORMAT is a utility given in GOOGLE SHEETS which is used to copy the format of one text to the other within a fraction of a second.

PAINT FORMAT IS A TOOL IN GOOGLE SHEETS TO COPY THE FORMAT OF ONE TEXT AND PASTE IT ON THE OTHER AT A LIGHTENING SPEED.

PAINT FORMAT is a very useful tool especially when we have gathered the content from various sources or reports.

It helps us to directly copy the Font of one content to the other directly.

Format is the size, color , font etc. properties of the text.

BUTTON LOCATION OF PAINT FORMAT IN GOOGLE SHEETS

The button location of FORMAT PAINTER is present on the standard toolbar.

 

PAINT FORMAT BUTTON LOCATION
PAINT FORMAT BUTTON LOCATION

STEPS TO USE PAINT FORMAT IN EXCEL

  • Select the text, whose format you want to copy.
  • After selecting the text, click PAINT FORMAT BUTTON.
  • Click the text where you want to copy the format.
  • The text’s format will be exactly same as the one copied.
  • The following animated example shows the same process.

ANIMATED EXAMPLE TO USE PAINT FORMAT

HOW TO USE PAINT FORMAT IN GOOGLE SHEETS
FORMAT PAINTER ANIMATED EXAMPLE

EXPLANATION

In the above mentioned example, there are two texts, current format and intended format.

 

We select the intended format(The format which is desired, the one which is already there) , click on PAINT FORMAT and click the text whose format is to  be changed .

If we have a large text, after clicking the paint format button just select all the text and it’ll be

HOW TO CHANGE THE FORMAT OF LARGE TEXT IN GOOGLE SHEETS

If we have a large text whose format is to be changed follow the steps.
  • Click the INTENDED FORMAT. [ THE FORMAT TO BE COPIED].
  • Click the PAINT FORMAT button.
  • Without clicking anywhere, just select the complete text where we want to paste the format.
  • The complete text format will be changed.
  • The example above shows this working for the lower three rows.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: