Question: how do you copy the same format from one excel sheet to another?
Answer: Click on the Format Painter button on the Standard toolbar. [The Format Painter button is the one with the paintbrush.] Click on the sheet tab at the bottom of the screen for the sheet that is to receive the formatting, or open another Excel file that you want to format. Click on the Select All button in the new sheet.