| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how could i detete lots of rows by one commond
i have 50000 rows in first sheet and in second sheet 10000 unique id i have
how could i delete 10000 entire rows in one time from first sheet, pls help me out as i am worry about it, i am using 2003 version |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how could i detete lots of rows by one commond
Use autofilter
1) Data - Filter - autoFilter 2) Select unique ID 3) Highligh rows with ID 4) Data - Filter - Autofilter (removes filters os you now have all the other data) "Amit Mahar" wrote: i have 50000 rows in first sheet and in second sheet 10000 unique id i have how could i delete 10000 entire rows in one time from first sheet, pls help me out as i am worry about it, i am using 2003 version |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing *lots* of rows | Excel Discussion (Misc queries) | |||
| MS Query uses lots of CPU | Excel Discussion (Misc queries) | |||
| Selecting lots of charts | Excel Discussion (Misc queries) | |||
| lots of data | Excel Discussion (Misc queries) | |||
| hOW TO DELETE THE - IN (23-HFV51), I HAVE LOTS OF ROWS WITH DATA. | Excel Discussion (Misc queries) | |||
Linear Mode
