In this tutorial I am going to discuss how to create an Excel template from an existing Excel spreadsheet that you use often and are happy with but which only needs new data entered for each new period.
Very often with Excel we find ourselves using the same basic spreadsheet over and over just adding the new data for each period. For example monthly budgets, sales figures, annual rainfall or monthly planners. The spreadsheet may have been through several tweaks to eventually arrive at the version that works best for you. When you arrive at this point you don’t want to create the spreadsheet from scratch for each new period which could be daily, weekly, monthly or annually. This would be time consuming.
Ok let’s go through creating an excel template, stepbystep
1. Select the existing spreadsheet including all headings and formulae.
2. Right click Copy
3. Open a new Excel workbook
4. Select a cell near the top left –right clickPASTE. Choose the paste option that shows the spreadsheet exactly as you copied it. Usually first paste option.
5. Carefully select only data in the spreadsheet and press DELETE
6. Check formulae are still functional by entering a few test figures – if OK then delete these figures.
7. Save workbook by clicking SAVEAS then give it a file name such as ‘Rainfall template’. Then under file name ‘SAVE AS TYPE’ drop box select ‘EXCEL TEMPLATE’ and SAVE
8. Now, by default, Excel saves templates in C:Documents\Custom Office Templates, but you can save them wherever it makes sense to you.
9. To change the save location you will first (before saving the template) need to create a new folder in File Explorer eg Excel Templates. Then On the “Excel File” menu, click the “OPTIONS” command. In the “Excel Options” window, click the “SAVE” category in the left column.
10. On the right, you’ll see a “Default personal templates location” box where you can type a path to a custom save location for templates. There’s no “Browse” button for some reason, so type the full path to the folder you want to use or copy and paste the location from a File Explorer address bar.
11. To use this template you can start a new work book by double clicking on your template file. If you want to add the template as a spreadsheet in an existing work book then select and right clickCOPY the open template spreadsheet. Then go to your existing work book, open a new spreadsheet, select a cell near top left. Then right clickpaste. Right click the sheet name click rename and give it a name like “Rainfall Template” and perhaps move it into the position of the first spreadsheet in that work book.
12. Start entering the new data.
13. In this example (Rainfall) I will open a new spreadsheet for each year to copy the template into a new spreadsheet (period). Right click on the template then select from this menu MOVE or COPY. Then select (MOVE TO END) and tick the box “CREATE a COPY” This will create a new spreadsheet to the right which will be named template(2). Right click and rename it according to your next period eg 2021 etc.

Why not watch the whole Excel tutorial course of 7 videos for beginners here:
   • Excel beginner's tutorial: create you...  

Comments are most welcome, if you decide to try this please send us some feedback☺ Why not visit our channel and browse through our other videos?    / annerasmus  
Video Chapters time stamps
Here are some time stamps for browsing the content of this video:
00:00 Beginning
01:11 How to select and copy an existing Excel spreadsheet to be used for a template
01:58 How to remove existing data but retaining formulae in Excel template
02:31 How to save a template in default location for future use
04:12 How to save Excel template in custom location on your computer
07:02 Importing a copy of an Excel template into a new workbook

To view the Blog article covering this subject, click on this link: https://basiclowdown.com/createanex...

Short Disclaimer/disclosure: My videos/articles are for informational and educational purposes only, you should consult with a professional before attempting anything seen or done in my videos/articles. Please read full disclaimer here: https://basiclowdown.com/disclaimerd...