To make it easier to see which cells contain formulas, I'll go ahead and add a fill to these cells. When I click OK, all formulas in the worksheet are selected. We can easily do that by using Go To Special and then selecting Formulas. Let's take a look through the formulas in this model to see how they work.įirst, let's find all the formulas. Here we have a simple model that shows the expense of making coffee at home vs. ![]() ![]() In this video, we'll look at how to quickly find formulas and trace how they are related to one another using the concept of precedents and dependents.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |