Templates

Resolved · Low Priority · Version 2013

Wed 16 Aug 2017, 16:33 Delegate Linda said...

Linda has attended:
Excel Intermediate course

Templates

Remind me how to set up templates

Fri 18 Aug 2017, 11:46 Trainer Jens said...

RE: Templates

Hi Linda,

Thank you for the forum question.

Create a normal Excel workbook. Add everything you want in the template. When you have finished it click the File tab in the ribbon and click Save As.

Click Browse and in the Save As dialog box change Save as type to Excel Template. Do not change it to another folder. Just give the template a name and click Save.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 25 Aug 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips