From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 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] On the Home tab in the ribbon, 2 the far right button in the Editing group, 3 is called Find & Select, 4 and lots of interesting choices and valuable choices here, 5 including one called Go To Special. 6 I've depicted the Go To Special dialogue box 7 on this worksheet off to the left. 8 A number of these choices here are available 9 by way of keystroke shortcuts, 10 and a number of them are also available by some 11 of the choices that we see on Find & Select. 12 So let's take a look at some of these options here. 13 I'm going to go to the first worksheet in this workbook, 14 and imagine that I'm interested in seeing 15 where the comments are. 16 Now I can see the red triangles here. 17 Imagine the worksheet possibly is much larger. 18 I might want to simply highlight all of these. 19 By going to Find & Select and Go To Special, 20 the first choice says Comments. 21 Click OK. All a comment cells are…

Contents