Imagine you receive a workbook from your colleague.
It has a sheet that includes a lot of data and you want to quickly recognize which of these cells
have formulas and which of them are input.
You can use "go to special". "Go to special" is another really helpful but hidden feature that's not known
by a lot of Excel users.
So here we just have a small dataset and I'm going to demonstrate what go to special can do.
Just by looking at this.
I can't tell what are the formula cells in here.
I'm going to go to "go to special". Go to home, on the right hand side here where you see find and select.
There is go to "go to special" and then you will see other features here.
These actually belong to "go to special".
So if I just want to highlight the formula cells on this sheet, I just have to select formulas and they're
already highlighted, now the totals are fine.
These look like they have formulas too
and this number also has a formula behind it.
The good thing is because they're all selected I can go and I can add a color to this.
I can go and make them green and just take a look at the formula cells. And then go back to this and see
what type of formula is behind this.
This one looks like it's an input and these have formulas so it's referencing this cell minus one, this
cell minus two.
So I'm just gonna press control+z to go back.
Now what if I wanted to see all the constants on this sheet.
I can do that too.
I can go to find and select and select all the constants. And I immediately noticed that this cell is
not an Input cell.
You can also select specific areas.
So if I just highlight this here and I say I want to see the constants only in this selection, I just
have to do the highlighting before I go and select constants.
Now let's take a look at more options directly under go to special.
This takes us to this view where we have even more options.
So we see the constant and the formulas option we saw before but here we can actually decide what type
of constants we want to get.
So let's say I don't want to have any text constants.
I'm going to take the tick mark away and the selection here should disappear and I click on OK then
it's only these numbers that are selected. The shortcut for go to special is Control+g
and then you can press Alt+s to go to special or just select special.
Now this time again let's select a constant.
Let's just have the numbers and no text and click on OK.
And I can highlight the input cells differently.
So let's go and highlight them in this light yellow color.
Now for this one that should actually be a constant and not a formula.
I want to remove the formula behind this.
Just keep the number.
So I'm going to right mouse click this, select copy or just press Control+c and then right mouse click
and under paste special.
The second option here is to paste as values which means just keep the number but take away the formula
behind it.
So now let's just try that again.
I'm going to highlight this area.
I'm going to go to find and select.
I don't have any text here so I'm just going to select the constants directly from here and then use
the color here.
OK so that's how easy it is to recognize formula and input cells in your worksheet.
Now we are going to take a deeper look at the other options in go to special especially when we take
a look at cleaning data.
So lots of fun stuff coming out.
Make sure you do the exercises so you don't forget everything you're learning.