Loading existing sheet as new sheet with same data

Occasional Visitor



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

1 Reply


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.