excel

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

Excel

resolvedResolved · Low Priority · Version 2003

Hayley has attended:
Excel Intermediate course
Word Intermediate course

Excel

When you are creating a template is it possible to create and save to the programme so that you can bring it up any time after?

RE: Excel

Hi Hayley,

Thank you for your question and welcome to the forum.

Do you mean can you save the template for further use?

If so, when you save the template, when you change the Files of Type to 'Template' it will save the template to the C drive on your local machine. If you then need to create a new document based on that template you need to go to File - New and then choose Templates On My Computer and choose the General Tab. Finally double click on the template.

If you need the template to be available to everyone in the company save it to a Shared Network Drive.

I hope this answers your question.

Regards

Simon

Thu 18 Nov 2010: Automatically marked as resolved.


 

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips


Server loaded in 0.09 secs.