Loading existing sheet as new sheet with same data

%3CLINGO-SUB%20id%3D%22lingo-sub-2514271%22%20slang%3D%22en-US%22%3ELoading%20existing%20sheet%20as%20new%20sheet%20with%20same%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2514271%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20use%20your%20initial%20worksheet%20as%20a%20permanent%20template%20so%20when%20i%20open%20a%20new%20sheet%2C%20it%20will%20have%20the%20same%20text%20as%20the%20first%20sheet%3F%20instead%20of%20having%20to%20copy%20the%20sheet%20everytime%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2514271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2514422%22%20slang%3D%22en-US%22%3ERe%3A%20Loading%20existing%20sheet%20as%20new%20sheet%20with%20same%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2514422%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1095209%22%20target%3D%22_blank%22%3E%40ParkerJC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20every%20new%20sheet%20in%20every%20workbook%20to%20be%20a%20copy%20of%20that%20sheet%2C%20it%20would%20be%20possible%2C%20but%20I%20assume%20that%20is%20not%20what%20you%20meant.%3C%2FP%3E%0A%3CP%3EFor%20a%20single%20workbook%2C%20you'll%20have%20to%20copy%20the%20first%20sheet%20each%20time%20you%20need%20a%20new%20sheet.%20If%20you%20wish%2C%20you%20could%20create%20a%20macro%20for%20that%20and%20assign%20a%20keyboard%20shortcut%20to%20it%2C%20and%2For%20a%20custom%20Quick%20Access%20Toolbar%20button%2C%20but%20that%20seems%20a%20bit%20over%20the%20top.%20Let%20us%20know%20if%20you%20want%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply

@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.