Before using the current worksheet setting to create a template, you must save the worksheet first.
-
From the View menu, select Templates, Manage Templates.
-
In the Manage Worksheet Templates dialog, click Capture.
-
Enter the template name then click OK.
Now that template is saved, it can be applied to any other worksheet. If you need to make changes to it, you can edit, rename or delete it.