How to Remove Circular References in Excel. In a Microsoft Excel 2010 spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate.

2] Remove dashes in Excel by using the Find and Replace method This method does not work if a particular format is already applied to your cells, say SSN (Social Security Number) format.

Protected and unprotected cells look the same in a spreadsheet. To delete all unprotected cells, you must select all of them at once, which can be easily done by using the Find and Replace feature.

To delete an Excel pivot table, select all the cells in the table and press Delete on your keyboard. A pivot table is a helpful Excel tool to view your data, but you might not need to keep it ...

To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.