How to use Format Painter in Word, Excel

How to use Format Painter in Word, Excel


Using and editing text is a pretty time consuming job if you have to work with a file with very long content. Through this article, you will learn how to use the Format Painter tool in Word and Excel to align effectively and quickly.

Related posts

  • How to type a caret in Excel
  • How to type degrees C, square meter, cubic meter, square, exponent in Word and Excel?
  • How to create a Hyperlink, link in Excel
  • Sum formula in Word, Excel
  • How to hide, show the Ribbon toolbar in Word, Excel


Tools and features of Office software are always updated and improved to better support the needs of users. And the Forrmat Painter tool is one of the most useful tools to help you save time and increase accuracy when designing and editing word and excel files.

Instructions for using Format Painter in Word, Excel

Use the Format Painter in Word

Step 1 : You highlight the rich text that you want to copy for other text. Then you click Forrmat Painter on the toolbar. At this point the mouse pointer will appear with a broom-shaped icon

Step 2 : You highlight the text you want to edit. At this point the text will have the same format as the text in step 1, and here is the result.

Step 3 : Do the same with the text below

Step 4 : And here is the result after using it Format PainterYou have got the text you want

Use the Format Painter in Excel

Step 1 : You click on the excel cell with the format you want to copy to other excel cells. Then you click Format Painter on the toolbar. At this point the mouse pointer will appear with a broom-shaped icon

Step 2 : You click on the excel cell you want to edit. At this time, the excel cell will have the same format as the excel cell format in step 1, and here is the result.

Step 3 : Do the same, and you’ve got the spreadsheet you want.

So you already know how to use the Format Painter in Word, Excel aligns effectively. With this trick as well as popular Excel functions such as VLOOKUP or HLOOKUP, you will greatly increase your working speed and you can also work with word and excel in a much easier and easier way. .

https://thuthuat.taimienphi.vn/su-dung-format-painter-trong-word-excel-2436n.aspx
In addition, if you are working with documents or spreadsheets related to dates, you will need to format dates to create the most accurate data files.

.

Related Posts