When you discover an error in Microsoft Excel, and that error is part of a formula, then the level of difficulty in resolving the problem can vary greatly. Hopefully it is as simple as checking all of the data for a number that was entered incorrectly. Unfortunately, however, you might be working with formulas that count on the results of other formulas, which can make troubleshooting more difficult.

One helpful way to deal with this problem is to highlight all of the cells in your worksheet that contain a formula. This can offer a quick way to identify all of the cells where a calculation is occurring, which can aid in your troubleshooting efforts.

## Quickly Highlight Cells Containing Formulas in Excel 2010

The steps in this article will show you a simple way to identify all of the cells in your Excel spreadsheet that contain a formula. If you click on one of those cells, then the formula contained within the cell will be displayed in the Formula Bar above the spreadsheet, as in the image below.

Step 1: Open your worksheet in Excel 2010.

Step 2: Click the **Home** tab at the top of the window.

Step 3: Click the **Find & Select** button in the **Editing** section of the Office ribbon, then click the **Formulas** option.

Excel will automatically select the first formula in the spreadsheet, then the rest of the cells containing formulas will be highlighted in blue. For example, in the image below, cells **A2**, **C5**, and **D2** all contain formulas. The formula in **A2** is selected because it appears first. You can cycle between the highlighted cells by pressing the **Enter** key on your keyboard.

Would you like to change the settings in Excel 2010 so that it shows the formulas in the cells instead of the results of those formulas? This article will show you how to switch between showing the formula and the formula result in your worksheet.

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.