Auto Filter lists

  • Thread starter Thread starter Mark W
  • Start date Start date
M

Mark W

Hello

I'm using Excel 2000 and someone has asked me to set up a spreadshee
to enter personnel training records.

In some of the cells i'm wanting to give the inputter options o
picking from a list of outcomes. What is the best way to set this u
so that I can then filter out certain ones?

For example one of the columns will be whether they attended a full o
part time course. How would I set up the drop down box to give the
the option of picking full or part time and then filter out all th
full time courses.

Thanks in anticipation for any help you can give me.

Mar
 
Back
Top