Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel: Selecting Multiple Rows
Name: jasonx Date: December 11, 2005 at 17:26:27 Pacific OS: Windows XP CPU/Ram: P4 1GB Ram
Comment:
Hi guys,
I have a worksheet in excel.
It basically has a bunch of columns and shows.
What I want to be able to do is select rows which match certain text in a column and paste these entire rows into a new worksheet.
EXAMPLE Sheet1 A B C 1 a male 2 b female 3 c male 4 d female
If I wanted to get all the males into a new sheet then my sheet would look like this: Sheet2 A B C 1 a male 2 c male
Summary: I'm running across the same issue as a previous poster ( http://www.computing.net/answers/of... ) in Excel 2007. Namely, that often when I click on a cell in excel, that cell and several cells below ...
Summary: Just wondering if there is anyway I can colour the highlighting of columns or rows i.e. when I select multiple rows and columns in excel, the selection is so faded that sometimes I can't really mak...
Summary: Is it possible to have multiple rows of worksheets. That way you won't need to scroll over if you have more than what would fit on only 1 page? ...
0 
