![]() ![]() ![]() This may include applying borders, formatting the headers, adjusting column widths, removing gridlines, etc.Īnd while you’re patting your back for turning ugly data into a beautiful one, you get another file that needs to be formatted the same way. You get plain ugly data from a colleague, and you spend the next few minutes applying some formatting to make it beautiful. Keeping the Format Painter Active (to reuse it multiple times)Įxcel Format Painter is a nifty tool that allows you to copy formatting from a range of cells and paste it somewhere else in the worksheet (or other worksheets/workbooks).Example 2 – Copying Conditional Formatting using Format Painter.Example 1 – Adding formatting for an Extended Dataset.Using Format Painter in Excel – Examples.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |