Re Use the Format Painter

Please purchase the course before starting the lesson.

Although not part of Paste Special, the format painter does something similar in that you can copy a cell’s format and paste ONLY the format onto other cells.

The format painter allows you to copy a format and paste it onto cells. So below, if we wanted to use the currency format in B14 we can use the Format Painter to copy the format to other cells.

Re Use the format painter

The problem is that if the cells you want to ‘paint’ are not next to each other you may need to keep clicking on the example cell and clicking the format painter button. This is easily solved.

To see the full course contents click here.

Back to: Intermediate Excel Course > The Specials- GOTO and Paste