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 · Medium Priority · Version 2007

Cedric has attended:
Excel Intermediate course

Excel

How do we create a new template ?

RE: Excel

Hi Cedric

Thanks for your post - sorry for my late reply

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:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips


Server loaded in 0.08 secs.