00:00okay guys i need to show you something here quickly and zip out of here on your data set
00:04how do you tell which cell has a formula a manual way to do is to individually select a cell
00:09and
00:09see whether it has a formula and if it does it looks something like that but if you have to
00:14do
00:14in a massive scale there's three ways to do it the first method will be to use a function called
00:20is formula and it only takes one argument that will be the cell location reference you select
00:25the cell like this close parenthesis and hit enter and if it if that cell has a formula it return
00:31true
00:31if it does not have a formula it returns false like this method number two is to use the hotkey
00:37you press ctrl tilde and what it does is that it changes the whole spreadsheet into a single text
00:43like this every cell is treated like a single text so any cell that has a formula it becomes visible
00:50to you and this technique is really good where you can do ctrl f and do search and replace of
00:57massive formula like for example if you want to change the sum to say aggregation aggregate i'm
01:02sorry you can do it here in a massive scale because all the formulas are treated like a string now
01:08if
01:08you're going to go back to your original data set you press ctrl tilde one more time again like this
01:12and you're back to your data set with the formula all running method three would be to use find and
01:18select you're going to go and select home from your ribbon and then under editing there's find and
01:23select here like this and you click on this a context menu appears click on formulas and any cell
01:29that has a formula in it will be highlighted now you can go ahead and change the cell color and
01:34any
01:35cell that has a formula will be visible to you
Comments