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

templates

ResolvedVersion 2003

Nicola has attended:
Excel Intermediate course
PowerPoint Introduction course

Templates

How do I create a template?

RE: Templates

Hi Nicola

Thanks for your post - Welcome to the forum hope you enjoyed the Training

All you need to do when you have created your spreadsheet as you want it to look what you will need to do then is save your file as a template and then give it a name

To then use the template what you do is - Go to the office button and choose new when the window opens up what you do then is from the lefthand side is select my templates and you should find it there - just double click it to open - if you get any trouble with this just relpy to this post

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Thu 22 Jan 2009: Automatically marked as resolved.

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.