Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .