From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Discovering time-saving tools in the Go To Special feature

Discovering time-saving tools in the Go To Special feature - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Discovering time-saving tools in the Go To Special feature

“

- [Instructor] Excel has a valuable set of tools, somewhat buried in the menu system under the category of Go To Special. On the Home tab in the ribbon menu system, way off to the right in the editing group, you'll see Find & Select with some good choices here, including Go To Special. These choices are being depicted in the green panel on the left side of the screen here, quite a few choices, that's the way the dialogue box appears. You can also get here quickly by pressing the F5 key and Special. We're going to take a look at some of these within the context of, say the current data that's on this worksheet. So I'll move this green panel over. Some of these features also have keystroke options too, you see those over in columns M and N. So, we can see on this worksheet that there's conditional formatting in column H and column J, but is there any other conditional formatting? Doesn't look like it. However, to be sure,…

Contents