Excel help (again)

Started Jan 19, 2012 | Discussions thread
scrambler2
Contributing MemberPosts: 544
Like?
Re: Excel help (again)
In reply to guiri, Jan 22, 2012

Assuming your excel file includes a number of columns for each type of information, you just need to add one more colum in which you will enter the information you want to sort/filter by.

Once this is done, you need to create a table with the whole thing. This will create a drop down list for each colum title and allow you to filter or simply order the way you want.
Here is the link on how to create and use a table in excel

http://office.microsoft.com/en-us/excel-help/overview-of-excel-tables-HA010048546.aspx

Reply   Reply with quote   Complain
Post (hide subjects)Posted by
Keyboard shortcuts:
FForum PPrevious NNext WNext unread UUpvote SSubscribe RReply QQuote BBookmark post MMy threads
Color scheme? Blue / Yellow