![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |