Blonde Moment - Excel Question
#1
Scooby Regular
Thread Starter
Join Date: Jul 2001
Location: deep inside your imagination
Posts: 24,057
Likes: 0
Received 0 Likes
on
0 Posts
Can someone please help me to delete a large proportion of an Excel spreadsheet.
The spreadsheet has around 1000 rows. Around 600 rows have common data in one of the columns, and I want to remove those 600 rows from the table and either paste them to a new worksheet in a new file, or delete them permanently.
Have attempted to do this by using autofilter to only show the rows that meet the criteria, then deleting the rows but this seems to also delete the rows which are filtered out. Have also tried the same but cutting/pasting the selected rows to a new sheet, but this has the same effect.
I'm sure there is a straightforward method to do what I need, but had a mental block today, and cannot get my ickle brain round it
Edit cos I cant spell either
[Edited by Figment - 8/5/2002 11:40:48 PM]
The spreadsheet has around 1000 rows. Around 600 rows have common data in one of the columns, and I want to remove those 600 rows from the table and either paste them to a new worksheet in a new file, or delete them permanently.
Have attempted to do this by using autofilter to only show the rows that meet the criteria, then deleting the rows but this seems to also delete the rows which are filtered out. Have also tried the same but cutting/pasting the selected rows to a new sheet, but this has the same effect.
I'm sure there is a straightforward method to do what I need, but had a mental block today, and cannot get my ickle brain round it
Edit cos I cant spell either
[Edited by Figment - 8/5/2002 11:40:48 PM]
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
bluebullet29
General Technical
9
05 October 2015 02:17 PM