from a table i want to copy & paste those rows which contain a particular word or data. Is there any shortcut method or i will have to manually select all those lines. one more question when i manually select in excel on my office pc, it says multiple selection not allowed but on my home pc it allows. Why is it like that
2007-03-05 23:35:34 · 1 answers · asked by sam 3 in Computers & Internet ➔ Software
Try filtering your info. Go to Data - Auto Filter.
Then you can select your info. Click on the down arrow from one of the columns your info is in. If you are looking for a particular word or data, click on Custom from the pull down menu. Then box opens up. Select "contains" in first box, and in next box type in what you are looking for. Should find all the info that matches that. That should pull up your info. You can copy it from there easily into a another doc.
Let me know if it doesn't work.
2007-03-05 23:53:54 · answer #1 · answered by mikea_va 6 · 0⤊ 0⤋