Carpe diem: Excel - Sorting By Columns

Excel – How to sort using different and multiple columns

These are the basics for sorting and there are other options etc. that I have not explored.  If you have more to add, let me know!

Anytime I use the sort feature, I ALWAYS click on the ALL button to assure data is kept together. 
(See picture for ALL button) 

The easiest and most commonly used sort is by name in the first column.

                       Thumbnail

To sort by other columns you start with the ALL button, Data Tab, Sort icon.  A new window will open to choose what column you want to sort.  Check the box to show headers (usually by default will be checked if you have used headers).  Click on the chevron by the Sort by row to get a drop down box listing all your column headers.  Click on the header you want to sort by.

If your spreadsheet does not have headers, you can still sort using the same method but you will sort by column letters.

                      Thumbnail

If you want to sort the data even further using more columns, click on Add Level, click on the chevron and choose the header.  This would be useful if you had a sheet on plants and wanted to sort by bloom color, then bloom time, then name you could easily see which plants fit in those categories.

                       Thumbnail

This is my spread sheet sorted by name.

                       Thumbnail

This is my spread sheet after I sorted by 3 columns; Test 1 Read, Name, Grade.  Hard to see but you get the picture!  LOL

                       Thumbnail

Questions, corrections or comments; Click Excel Forum.

« Return to Carpe diem

« Return to the Pages table of contents.

Carpe diem

This is a meeting place for people all over the world to discuss and share information about all areas of this ever shrinking globe. NEW!! I have added a forum for discussions about using Excel and tutorials in the PAGES section.

» Home
» Forums
» Articles
» Pages
» Links

Cubit owner: weeds

Admin team:

» Contact the admins













Want to browse around and see what other Cubits are about? Try the Cubit Finder