O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Go To Special Dialog Box

The Go To Special feature is far more powerful than the Go To feature. Whereas the Go To dialog box allows you to navigate directly to a particular cell, the Go To Special dialog box allows you to select multiple cells that all meet particular criteria. This feature is particularly handy when you want to avoid manually navigating through a large worksheet to select multiple cells by pressing and holding down the Ctrl key. But the feature also works well for finding a single cell in a worksheet that meets the desired search criteria or for selecting a contiguous range of cells that all meet the criteria. The Go To Special feature works only on the currently selected worksheet.

When you use this feature, selected ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required