templates

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Templates

resolvedResolved · Medium Priority · Version 2003

Sonia has attended:
Excel Intermediate course

Templates

can i use filters on a template?

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 tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips


Server loaded in 0.09 secs.