How to Select the Cells Containing Formulas in Excel 2010

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.

excel 2010 formula bar



Step 1: Open your worksheet in Excel 2010.


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

click the Home tab



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

click find and select, then click formulas



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.

selected formulas



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. newsletter
vintage t rex t-shirt

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