(Closed) Any Bees on here excel savvy?

posted 5 years ago in College
Post # 3
Member
407 posts
Helper bee
  • Wedding: June 2015

@sunkissed19:  Click the little arrow in the upper left corner. That should select everything. 

Then click sort and filter, right hand side at the top
Custom sort, uncheck my data has headers, and sort by column A 

Post # 4
Member
11747 posts
Sugar Beekeeper
  • Wedding: November 1999

Highlight the header cell go to data >filter. Then click on the icon in the top right of te cell and sort smallest to largest

Post # 5
Member
605 posts
Busy bee
  • Wedding: March 2014 - Brazil Room

So to create a “database” for sorting, you can do it like this. Highlight the data you want including the titles. In the “name box” on the left (where it usually shows the cell number (A1, C24, etc) type in any name you want and then press enter. Now whenever you click the dropdown for that box, your database will be listed.

Then right-click in the column you want to sort and go to “sort” as pictured. Hope that helps 🙂

 

The topic ‘Any Bees on here excel savvy?’ is closed to new replies.

Find Amazing Vendors