You can now quickly copy the formatting you had already done, and paste it into the new dataset.Īnd woosh. This is where Excel Format Painter comes into the picture and saves you a lot of time. 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 kommentar(er)
