Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Templates

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Templates

Resolved · Medium Priority · Version 2003

Reply Thu 29 Oct 2009, 16:22Delegate Sonia said...

Sonia has attended:
Excel Intermediate course

Templates

can i use filters on a template?

For upcoming training course dates see: Pricing & availability

Reply Fri 30 Oct 2009, 09:23Trainer Simon said...

RE: Templates

Hi Sonia,

Thank you for your question and welcome to the forum.

When you create the template, you can turn on autofilter and then save the template.

Every new workbook created from the template will have the autofilter automatically turned on.

You can use Autofilter on any workbook created from the template.

I hope this answers your question.

Regards

Simon

Thu 5 Nov 2009: Automatically marked as resolved.

Excel articles

· How to Create Better Excel Spreadsheets: Part Two
· How To Learn From Your Excel Mistakes
· How To Create A Real Line Graph In Excel 2010 Rather Than A Line Chart
· Tools From Advanced Excel Courses: Goal Seek and Solver
· A Blinking Good Excel Tip

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips