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.

To remove a single manually added page break in Excel, select a cell in the row immediately below the primary page break.

When you need to format text in multiple ways in a single cell in Microsoft Excel, then this guide shows you how to do it the easy way.

Errors can occur in Excel due to users typing the wrong formula references, accidentally deleting an important cell or row in the spreadsheet, and more.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

How to create color scales in Excel If you prefer, you can also use color scales rather than data bars.