This can be handy when trying to quickly identify all cells that contain formula errors. When you select the Formulas radio button, the dialog allows you to be more specific and pick and choose formulas that return numbers, text strings, logical values, and errors. When you Go To Formulas, Excel selects cells that contain formulas. If you want a way to quickly unlock input cells, you can go to constants, and then unlock them at one time. When you apply worksheet protection, by default, all cells are locked. This can be handy when setting up worksheet protection. When you select the Constants radio button, the dialog allows you to be more specific and pick and choose numbers, text strings, logical values, and errors. Basically, this includes cells that have entered values and excludes empty cells and formula cells. When you Go To Constants, Excel selects cells that contain stored constants. I’ll highlight just a few of them in this post. There are a bunch of fun options to play with. This dialog has changed a bit through the different versions of Excel, so depending on which version of Excel you have, your dialog may have slightly different options. Clicking it brings up the Go To Special dialog, shown below. So far so good? Good, now, let’s investigate that little Special button in the lower left. For example, if our workbook had two named references co_name and commission_rate, then calling up the dialog box would allow you to select a name, as shown below. Typically, the Go To dialog box is used to quickly navigate to named references. If you are more of a ribbon person, then you could use the following command icon to display the Go To dialog shown below: There are a few different ways to display the dialog, I personally like to use the F5 key. This post explores some of these special destinations.įor starters, let’s call up the Go To dialog within an empty workbook. Have you ever called up the Go To dialog in Excel? There is a little button in it that enables you to go to special places in Excel.

Excel 2016 select visible cells icon