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

Automatically sending multiple parts of text from one word doc to another - is possible. 0
Creating a Chart on form from selected data in query. 0
Finding and Replacing Data in a Header Row 0
Linking data in MS Word into Excel 5
Macro Challenge – Create Table with Hours Worked and Copy Data 0
New computer, how do i move outlook 365 ENTIRELY? 0
How to make one standard "extension" in a column? 5
How do I clear a form? 0

Top