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.

Okay this is hard to explain.

I have a massive spreadsheet with sets of data in it. Each set has 'type' column (eg: system, memory, video card, etc). I need to be able to search within this column for a specific type and then be able to copy the entire row. I need this to work with multiple cells selected and then copy the multiple rows.

Basically, there's around 10 rows, all listing parts of a computer with its serial number, part number, date of purchase, etc, and I need to be able to extract only a few of those rows and put them in a new spreadsheet.

I am using Excel Office XP (2002) on Windows XP SP3.

Here is an example of the data from the spreadsheet: ( http://imgur.com/GdKo2.png ) example

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Not sure I completely understand from your explanation, but I think what you need is to Filter.

Try selecting your full data set and then goto Data|Filter. That will give you a drop down on your column headings and allow you to chooose only those Items that you're interested in.

share|improve this answer

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.