Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an excel spreadsheet with 3 columns. The first column is merged downwards to be the length of the other cells and contains a document name. The other 2 columns contain an id and some text respectively.

The spreadsheet ultimately will contain extracts from about 100 documents and I would like to be able to filter by document to see the document specific rows, however when I try to set up filtering, I can only return the first row per document name.

Is there any other way to accomplish this task? I tried using grouping however I didn't really understand it.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

In Excel, merging multiple cells into one cell will keep the upper-left most data only. For example, if you merge the range A2:A6, only A2 will keep its value and A3:A6 will be blank. So, merged cells will be troublesome in your case. Instead, you can unmerge the cells in your first column, fill them with the related values (document names), and then use Filtering. Moreover, you can also use Pivot Tables (Insert > Pivot Table). Drag your first column's header (Document name) to Row Labels (in the Pivot Table Field List), and other column headers to Column Labels. You can change the design of your Pivot Table in whatever way you like.

share|improve this answer
    
Thank you this is exactly what I needed. –  ryangavin Jun 29 '10 at 20:08
    
You're welcome. –  Mehper C. Palavuzlar Jun 29 '10 at 20:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.