Select the cell or range. Double-click the Format Painter button on the Home tab Select the cells to copy the style. When you are done, click the Format Painter button again to turn it off