How do I make a button in an excel spreadsheet for sorting?

  • Thread starter Thread starter Mike Smith
  • Start date Start date
M

Mike Smith

I have a spreadsheet of historical data I am creating. Each row would be a
single project and there are several columns that have different information
about each project. I would like to create a button in the header of each
column that would give me an option to sort the rows by the custom values in
each column. For example I may want to see all union projects, or all
non-union projects, or all projects that were apartments or condos. I hope
this description makes sense.
 
Hi,

Have you tried pivot tables? I think it is the tool that best fits your
needs. With pivot tables you can filter the data the way you are saying.

Regards,
 
I unfortunately know nothing about pivot tables. I will have to read up and
see how to create one. I tried the wizard a couple times but it says the data
field is invalid.
 
Back
Top