[Fixed!] Excel Not Responding When Deleting Rows (4 Possible Solutions)

In times of deleting too many rows at a time, it is not impossible that Excel will not respond when deleting rows. As it is not an uncommon problem, its solution is also available. I will try to explain 4 possible solutions to Excel not Responding When Deleting Rows problem.

For more clarification, I am going to use a Dataset with Novel Name and Author titled columns.

Excel not Responding When Deleting Rows

I have taken 7010 rows of information to explain it more clearly.


Download Practice Workbook


4 Possible Solutions to Excel Not Responding When Deleting Rows Issue

1. Sort Data before Deleting

It is a very simple and effective possible solution to Sort the data before deleting to the problem Excel not responding when deleting rows.

Steps:

  • Firstly, Add Index to observe the Sort effect.

Excel not Responding When Deleting Rows

  • Then, go to Data and select Sort.

  • In the Sort by option, you can choose the way of sorting. I chose Novel Name to Sort.
  • Press OK.

Excel not Responding When Deleting Rows

Then, you will have the sorted dataset.

  • Now, choose the sorted data to delete. I selected to delete the rows containing The Return of the Native Novel as I sorted the dataset by Novel name.

  • Right-click to have the Delete option.

Excel not Responding When Deleting Rows

  • Select the Entire row
  • Hit OK.

Thus, we can easily solve the problem.

Excel not Responding When Deleting Rows

Read More: Excel Not Responding When Opening File (8 Handy Solutions)


2. Using Power Query to Solve Excel Not Responding When Deleting Rows

The Power Query is a smart way to solve the problem Excel not responding when deleting rows.

Steps:

  • Select all the data first.
  • Then, go to Data and click on From Table/Range.

A Create Table box will appear.

  • Input the table range.
  • Press OK.

Excel not Responding When Deleting Rows

The Power Query table will be created.

  • Now, Click on the tab next to the column header.
  • Select the cells that you want to delete. Here, I selected the cells containing the name Thomas Hardy.
  • Then, press OK.

Excel not Responding When Deleting Rows

A new window will open containing the sorted data.

  • Click on the Remove Rows to have the option of deleting rows.
  • Select your delete type. I selected Remove Duplicates.

Excel not Responding When Deleting Rows

Read More: [Fix:] Excel Formula Not Working Returns 0


Similar Readings


3. Uncheck Add-ins to Solve Excel Not Responding When Deleting Rows

Unchecking the Add-ins is a possible solution to solve the not responding when deleting rows. problem.

Steps:

  • Firstly, go to the File
  • From there, select
  • Click on Add-ins.
  • Then, choose Excel Add-ins and click on Go.

  • Uncheck one Add-in at a time and press OK.

Excel not Responding When Deleting Rows

Read More: [Fix:] Excel File Opens but Does Not Display


4. Open Excel Program in Safe Mode

The Safe Mode application is another possible solution to solve the problem of not responding when deleting rows.

Steps:

  • Go to the Search option from the Taskbar.
  • Then, search Run and Click on it.

  • Write excel.exe/safe in the Open section and press OK.

Excel not Responding When Deleting Rows

This should solve the issue.

Read More: Fix Excel Not Responding and Save Your Work


Conclusion

I have tried to explain 4 possible solutions to the problem of Excel not responding when deleting rows. I hope it will be helpful for Excel users. For any more questions, comment below.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo