excelquest23
Board Regular
- Joined
- Apr 8, 2006
- Messages
- 58
Hello,
I have a worksheet with over 12,000 rows and I'd like to delete the lower 7,000 rows. Everytime I try to highlight more than 500 rows to delete manually the screen locks up on me. Is there an easier way to delete this many rows at once manually or should I use some kind of macro? If a macro is the way to go, could someone please send me one if they have one handy?
Thanks!
I have a worksheet with over 12,000 rows and I'd like to delete the lower 7,000 rows. Everytime I try to highlight more than 500 rows to delete manually the screen locks up on me. Is there an easier way to delete this many rows at once manually or should I use some kind of macro? If a macro is the way to go, could someone please send me one if they have one handy?
Thanks!