how to copy the format of a sheet in excel?
Select the cell from which you want to copy the format. Press Ctrl + C to copy the selected cell to the Clipboard. Select the cell(s) to which the format should be applied. In Excel 2016, 2013 or 2010, press Shift + F10, S, R, and then click Enter.