Question: how to copy an entire excel sheet with formatting?
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.