Keeping the format painter on

If you make use of the format painter, you will love that it will exactly replicate the format of one cell onto another. It can be a problem though if you want to take the format of one cell and apply it to many cells all over the spreadsheet.

This is easy to do by just double clicking the format painter icon. It will stay active until you ESC out of it.


Learn more at our live advanced Excel courses in South Africa. Visit Live Excel Training page