Share via

How to delete thousands of rows in EXCEL 2016?

Anonymous
2020-09-02T20:17:09+00:00

I am working with EXCEL 2016 spreadsheets that have more than 10,000 rows.  I occasionally need to delete many of the rows, for instance, 9,500 of the rows.  I do not want to simply copy the rows that I want to keep into a new sheet.

I know that I can use the Shift key, select row number 501 and hold the Shift key while I scroll down to row number 10,000.  However, that takes a long time, and there must be any easier way.  I will appreciate advice.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2020-09-02T20:21:55+00:00

    Let's say you want to delete rows 501 to 10000.

    Press F5 or Ctrl+G to activate the Go To dialog.

    Enter 501:10000 in the Reference box, then press Enter or click OK.

    Either right-click anywhere in the selected range and select Delete from the context menu, or click the upper half of the Delete button in the Cells group of the Home tab of the ribbon.

    100+ people found this answer helpful.
    0 comments
  2. Anonymous
    2020-09-02T20:29:24+00:00

    Thank you for your response!

    Let's say you want to delete rows 501 to 10000.

    Press F5 or Ctrl+G to activate the Go To dialog.

    Enter 501:10000 in the Reference box, then press Enter or click OK.

    Either right-click anywhere in the selected range and select Delete from the context menu, or click the upper half of the Delete button in the Cells group of the Home tab of the ribbon.

    40+ people found this answer helpful.
    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more