Any Bees on here excel savvy?

posted 3 years ago in College
Post # 3
Member
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
Member
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
Member
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