How to Delete Highlighted Text in Excel

By Kirk Bennet

You can use Excel 2010, the powerful spreadsheet software from Microsoft, on your business computer to create spreadsheets for your employees and clients and also view spreadsheets you receive from them. If you highlight cells that contain text or receive a document that contains such cells and need to delete them, you can use the Find feature to select all items highlighted with a specific color and then delete them with the press of a button.

Launch Excel 2010 and open the spreadsheet that you want to edit.

Click the "Find and Select" button in the Editing group and choose "Find" from the menu to open the Find And Replace window.

Click the small arrowhead next to the "Format" icon and choose "Choose Format From Cell" from the menu.

Click on one of the highlighted text cells to select its formatting.

Click the "Find All" button to view all highlighted text results.

Press "Ctrl-A" to select all highlighted text from all cells, right-click one of the cells in the Excel document and select "Clear Contents" from the context menu to delete the highlighted text.

Press "Ctrl-S" to save the changes.

Warnings

Information in this article applies to Microsoft Excel 2010. It may vary slightly or significantly with other versions or products.

×