If you need to copy the formatting to various places on the same spreadsheet ... Painter icon in the Home tab will remain ...