Any Bees on here excel savvy?

posted 3 years ago in College
Post # 3
404 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
11668 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
610 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 🙂


Leave a comment

Sent weekly. You may unsubscribe at any time.

Find Amazing Vendors