Deleting a large range of rows in Excel

I'm working with a large file of 60.000 rows and I want to delete all rows from row  3 to 50,000.  I have been starting at the 50,000th row and highlighting the rows to delete until I get up to row 3.  This is time consuming with so many rows. 

Is there a better way to delete a large number of rows in excel?  Thanks!

Answer
Answer

In NameBox type A3:A50000 then hit Enter

Edit>Delete>Entire Row>OK

Gord

34 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated January 14, 2021 Views 8,328 Applies to: