Forum Discussion

ParkerJC's avatar
ParkerJC
Copper Contributor
Jul 04, 2021

Loading existing sheet as new sheet with same data

Hi, 

 

Can you use your initial worksheet as a permanent template so when i open a new sheet, it will have the same text as the first sheet? instead of having to copy the sheet everytime?

 

Thanks in advance

excel

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jul 04, 2021

    ParkerJC 

    If you want every new sheet in every workbook to be a copy of that sheet, it would be possible, but I assume that is not what you meant.

    For a single workbook, you'll have to copy the first sheet each time you need a new sheet. If you wish, you could create a macro for that and assign a keyboard shortcut to it, and/or a custom Quick Access Toolbar button, but that seems a bit over the top. Let us know if you want that.

Resources