Sorting

  • Thread starter Thread starter ~Jeff~
  • Start date Start date
J

~Jeff~

I have a excel file from a client. The top row contains the column
title/descriptions. Next to each title, within the cell, there is a small
box with an arrow on it. I click that and a pull down scroll menu folds out
and gives me categories to filter out the rows.

What is this function/object/whatever ?

How do I use something like this on my own spread sheets?

Thanks
 
Its probably Autofilter.

Try this on a sheet with a table of data

Select say row1, which normally contains the col headers (labels)

Click Data > Filter > Autofilter

The drop arrows should appear in row1
 
Back
Top