Peter has attended:
Excel Introduction course
Mark up sheets in excel with duplicate data
How do you save the base layout to further sheets without copying the whole sheet onto a blank sheet. Say if you have 12 sheets and need to transfer the basics information for future input of data.
Thanks
RE: Mark up sheets in excel with duplicate data
You can save a template.
FILE > SAVE AS
Give the file a name, as you would a normal file,
Select the file type TEMPLATE (*.xlt)
Click OK
This saves the file as a template in a TEMPLATE directory, which is available from FILE > NEW, Templates on my computer. This templatye can be edited and then resaved if you have any fundamental changes.