![]() Repeat formatting of entire rows or columns Select Format Painter to apply the formats to the rest of the table. The Format Painter can assist you in formatting quickly and well.Īpply formats to the first two rows that follow the headings. When you are facing a table with multiple rows, adding color to alternate rows might be the ultimate way to improve the readability of your table. You can press the Escape key to disable it. Imagine you need to format a great many non-contiguous range s of cells, coping the formats one by one would be a nightmare.ĭouble-clicking Format Painter will make all the difference. This trick is less well-known yet extremely effective when dealing with a large amount of data. Select the contents contain the formats you want to replicate and then click Format Painter in the Home tab. The Format Painter can help you copy text and style formatting and paste it to other cells. ![]() The most basic function: Repeat formatting In today’s case, we will take WPS Spreadsheet to illustrate. After reading this guide, you will have a new understanding of this nifty tool. Many people think the format painter can only be used to repeat formatting. ![]() As a must-have too l in WPS Office, Format Painter can be seen in WPS Writer, WPS Spreadsheet and WPS Presentation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |