This can help you format worksheets quickly and consistently. Then select the Format Painter button in the standard toolbar at the top of the screen The Format Painter The Format Painter lets you copy cell formatting and apply it to other cells. In this example, we have selected cell A3. First, select the cell that has the formatting that you wish to copy. Let's look at an example of how to use the Format Painter in Excel 2011. Home Where is Format Painter in Excel Mac