The GOTO Special button is surprisingly unknown. It has a number of tools, but its basic task is to work through an entire sheet and highlight all cells that have a certain characteristic e.g. it
- has a comment in it
- is a number only (no = sign)
- is a formula, etc
It means you don’t need to click on each cell while holding CTRL.
Learn about the GoTo special tool and all the ways it can help you. As shown below there are many options and each one is useful in a particular area.
To see the full course contents click here.