Stopping the Deletion of Cells in Excel

Excel is a powerful tool that allows users to organize, analyze, and manipulate data in a variety of ways. However, one of the most frustrating experiences for Excel users is accidentally deleting cells or data. Fortunately, there are several ways to prevent this from happening and to recover lost data if it does occur.

Protecting Cells and Sheets

One of the easiest ways to prevent accidental deletion of cells is to protect the worksheet or workbook. This can be done by clicking on the “Review” tab in the ribbon and selecting “Protect Sheet” or “Protect Workbook.” When a sheet or workbook is protected, users are unable to make changes to certain cells or sheets without entering a password.

To protect specific cells, select the cells you want to protect and right-click. Choose “Format Cells” and then click on the “Protection” tab. Check the box next to “Locked” and click “OK.” Then, protect the sheet or workbook as described above. The locked cells will be protected from deletion or editing.

Using Undo and Redo

If you accidentally delete cells or data, don’t panic! Excel has a built-in “Undo” feature that allows you to reverse your last action. Simply press “Ctrl + Z” or click on the “Undo” button in the Quick Access Toolbar. You can also use the “Redo” button to reverse the “Undo” action.

Recovering Deleted Data

If you’ve accidentally deleted cells or data and didn’t realize it until after you’ve saved and closed the workbook, all hope is not lost. Excel has a feature called “AutoRecover” that automatically saves a backup copy of your workbook at regular intervals.

To recover a deleted cell or range of cells, open the workbook and click on the “File” tab. Select “Info” and then click on “Manage Workbook.” Choose “Recover Unsaved Workbooks” and select the backup file you want to open. The backup file will open in a new window, and you can copy and paste the deleted cells or data back into your original workbook.


Accidentally deleting cells or data in Excel can be a frustrating experience, but there are several ways to prevent it from happening and to recover lost data if it does occur. By protecting cells and sheets, using the “Undo” and “Redo” features, and taking advantage of Excel’s “AutoRecover” feature, you can ensure that your data is safe and secure.


Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.