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

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.
 
C

Carlos Mallen

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,
 
M

Mike Smith

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a spreadsheet to calculate and email an alert? 1
Enter formula in a message box 1
Help with sorting data 3
Sorting block of rows with empty rows between it 1
Sorting columns horizontally 2
Disable Clear DContents command in excel - vba code?? 3
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
How do I find what is in a spreadsheet 4

Top