Browse » Home
Friday, October 19, 2012
How to Delete All Unprotected Cells in Excel Spreadsheet
1. Open the spreadsheet containing the unprotected cells that you want to delete. Go to the 'Edit' menu in Excel 2003 and select 'Find.' Go to the 'Editing' group on the 'Home' tab in Excel 2007 or 2010 and click 'Find and Select.' Choose 'Find' from the drop-down menu. You can also use the keyboard shortcut 'Ctrl F' to open the 'Find' dialog box.
2. Click the 'Options' button to expand the 'Find' dialog box. Click the 'Format' button to open the 'Find Format' dialog box.
3. Go to the 'Protection' tab of the 'Find Format' dialog box.
4. Clear the 'Locked' check box by clicking inside it to remove the check mark. Click 'OK.'
5. Click the 'Find All' button. Excel will select all of the unprotected cells in the spreadsheet, which may take a few minutes.
6. Press 'Ctrl A' to select all of the results. Click 'Close' on the find dialog box. Press the 'Delete' key or right-click any selected cell and choose 'Clear Contents.'