Where is format painter in excel

The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information.

If your work involves applying the same type of formatting to data sets, using Format Painter in Excel will save you a lot of time. You get plain ugly data from a colleague, and you spend the next few minutes applying some formatting to make it beautiful. This may include applying borders, formatting the headers, adjusting column widths , removing gridlines , etc. And woosh.. Note that when you click on the Format Painter icon in the ribbon, the cursor changes and you can see a brush in it.

This indicates that the format painter is active. You can use format painter to instantly apply the same formatting that is used in the existing data set as shown below. One of my favorite uses of Format Painter is to copy conditional formatting. Since conditional formatting allows you to specify multiple rules on the same data set, doing it again for different data sets could be time-consuming.

You can also go through our other suggested articles —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Download Format Painter Excel Template. Popular Course in this category.