The #NUM error occurs in your Excel spreadsheet when a function or formula contains invalid numeric values. Remove #NUM errors this way!

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.

Let’s see all these fixes in detail. 1] Remove dashes in Excel by using the Flash Fill method This is the easiest method to remove dashes from data in Excel. Flash Fill identifies the pattern ...

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.

How to Remove Duplicates That Are Case Sensitive in Excel 2007. By definition, Microsoft Excel 2007 considers a duplicate to be a row of data that matches another row in your worksheet exactly.