Find Your Cells that Contain Formulas- Quickly


Hello, Excellers. Welcome back to another #FormulaFriday #ExcelTips blog post in my 2021 Excel series. Today let’s take a look at how to quickly find your cells that contain formulas. Have you ever inherited a workbook? Have you ever been asked to update an Excel workbook?. Do you need to see which cells contain Excel formulas?. Also, do you need to quickly check the referencing of your formulas to ensure they are correct?.

So, I would say that no-one wants to manually check each cell, do they?. Imagine doing that with hundreds or even thousands of Excel cells. No thank you!. Or even worse, accidentally changing cells then have to find where the formulas are.  Here is a fast way to look at the worksheet and easily identify the formula cells.

Check Cells For Formulas.

All you need to do is follow the simple steps below:

  • Formula Tab.
  • Show Formulas.
show all Excel Formulas

Yes, that is all there is to this Excel tip. Once you hit Show Formulas the cells with formulas go from this

Then to this.

There is an Excel shortcut as well, for your shortcut lovers out there. Just hit Ctrl+~.

This image has an empty alt attribute; its file name is Excel-Rescue.png

Read All Of My Macro Monday Blog Posts

Read All Of My Formula Friday Blog Posts

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts