Excel Guides

Copying Formats to a New Worksheet in Excel

There are a few different ways that you can copy formats to a new worksheet in Excel. One way is to use the Format Painter tool. To use this tool, first select the cell or range of cells that have the formatting that you want to copy. Then click the Home tab on the ribbon and click the Format Painter button in the Clipboard group. Next, select the cell or range of cells where you want to apply the formatting. The formatting will be applied to the selected cells.

Another way to copy formats is to use the Paste Special command. To use this command, first select the cell or range of cells that have the formatting that you want to copy. Then press Ctrl+C to copy the selection. Next, select the cell or range of cells where you want to apply the formatting. Then press Ctrl+Alt+V (or go to Home > Paste > Paste Special) to open the Paste Special dialog box. In the Paste Special dialog box, select Formats in the Paste list, and then click OK.

You can also use VBA code to copy formats from one worksheet to another. The following code will copy all of the formats from Sheet1 to Sheet2:

Sub CopyFormats()

    Dim sht1 As Worksheet
    Dim sht2 As Worksheet

    Set sht1 = ThisWorkbook.Sheets("Sheet1")
    Set sht2 = ThisWorkbook.Sheets("Sheet2")

    sht1.UsedRange.Copy
    sht2.UsedRange.PasteSpecial xlPasteFormats
    
End Sub

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.