excel-training-advanced courses - Invoiving

Hi Celina, thank you for the post, I hope you enjoyed your Excel course, in answer to your question, the easiest way to set up a template is to prepare your worksheet in the normal way with all formulas and functions in place, ensure that any cells that you wish to enter data into are left blank and then save your worksheet as a template, choose the template option from the type of file in the Save dialog box, if you now save your template it will be available from the File New, Templates on my computer command, however you can in the Save As dialog box indicate a different place to save your template, ie on a server so that others can access it. If you wish to stop changes to your basic format you should lock the cells that you do not wish to have changed before saving as a template. Dont forget to open a template you can Right click on its icon and choose Open from the shortcut menu. I hope that helps, regards Pete.