excel-training-advanced courses - invoiving

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-training-advanced courses - Invoiving

excel-training-advanced courses - Invoiving

resolvedResolved · Low Priority · Version Standard

Celina has attended:
Excel Intermediate course

Invoiving

how to set up a template

RE: 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.


 

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips


Server loaded in 0.09 secs.