From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Using Go To Special

Using Go To Special - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using Go To Special

“

- [Lecturer] When you're trying to track down certain kinds 2 of data in Excel, 3 you can't overlook a feature found on the Home tab 4 in the ribbon. 5 Far right, you'll see binoculars in the older versions. 6 Now it's a magnifying glass, Find and Select. 7 There's some choices down here that are useful, 8 but Go To Special encompasses some of these 9 and a lot of others. 10 There it is, the Go To Special dialog box. 11 By the way, I've also depicted this on a separate worksheet, 12 the "Go To Special Dialogue Box". 13 You'll see it at the bottom of the screen. 14 On the current worksheet there are some comments. 15 They're indicated by red triangles, 16 and that's the first choice here, 17 it's automatically selected. 18 I'll click Okay, and it highlights those cells. 19 Now, of course, there could be other cells below 20 that are rows 20 and farther down and off to the right, 21 but let's say, after we do this…

Contents