How to use the Excel Go To Special Tool to find constants, formulas, blanks, row and column differences, conditional formatting and data validation.
In this section you will learn how to activate and use the Excel Go To Special Tool which allows you to highlight cells based on what you are looking for e.g.
The GO TO SPECIAL command is one of Excel’s best features, and probably the one that people don’t know about the most. Just to show you where it sits
So it’s a very quick way of traveling around your spreadsheet, and you can imagine with a very big spreadsheet this can be very useful.
So for example what I want it to do is
Again remember if you’ve got a section highlighted it will only look within that section, if you have one cell clicked, it’ll look through the whole section, so
So you can see that this is the manual way of doing what Spreadsheet Professional does in its painter, you can navigate across the sheets
There are a number of other useful features however in this feature, so let’s say we’ve got a big spreadsheet, and all over you can see these little red flags which are comments whcih are included. Now this is an old spreadsheet we want to get rid of those because they are relevant to our prior projects, you can work through the entire spreadsheet to try and find them, or
One of the other very useful features is the ability to actually see what is different about a row or a column. So if
As you can see this is the manual process of doing the maps in Spreadsheet Professional, where you’d need to go through every single row or column to identify differences.
Another useful feature of the GO TO SPECIAL, is to find cells that have got programming sitting behind them, so if we say
We can look for two areas, conditional formats and data validation and it’s not obvious to spot in the spreadsheet itself so
But what is important to understand, is the ability to navigate through your spreadsheet quickly and easily
Just to run through all the options that exist with GO TO SPECIAL.
Precedents and Dependents are quite useful, what it allows you to do is look at all the precedents or all the dependents. So for example we are currently clicked on inflation rate 5%,
Alternatively, you can look for
The problem with this tool is that is only looks at the current sheet. So unlike the Auditing toolbar where it’ll warn you if it’s being used in other sheets, this one doesn’t do that. So that’s the Dependents and you can do exactly the same with the Precedents
In general this is an extremely useful tool to get to know and it’ll make your life significantly easier especially if you don’t have Spreadsheet Professional loaded.
Occasionally when you have a spreadsheet that will be used for presentation you may want to neaten it up by either showing zeros in Excel or not showing the zero in cells that have a zero in them. We typically … Continue reading
If I understand the query below correctly, the one idea is to type some words in a cell, and then, while holding the ALT key down, click ENTER. Within the cell you will get another line. Hope this helps. Original query Hi, … Continue reading
The remarkable thing about Adrian's presentation is his ability to further change and adapt the focus of the course as issues arose. He was also able to keep the more skilled delegates challenged...– Alexander Proudfoot Consultants