Question: how to copy format of one excel sheet to another?
Answer: Select the cell with the formatting you want to copy., Select Home > Format Painter., Drag to select the cell or range you want to apply the formatting to., Release the mouse button and the formatting should now be applied.