From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Discovering timesaving tools in the Go To Special feature

Discovering timesaving 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 timesaving tools in the Go To Special feature

“

- [Instructor] On this worksheet off to the right, 2 you see a feature called Go To Special. 3 If you click on the Home tab in the ribbon off to the right, 4 you'll see at the Editing group Find and Select, 5 and we also see Go To Special. 6 That activates the dialog box 7 that we're seeing in the background. 8 There are lots of features here that are really valuable. 9 It's a feature that is overlooked. 10 We can also get to the dialog box by the function key F5. 11 Now, I'm looking at a worksheet here, 12 and I can see pretty obviously 13 that in column F and column H, 14 there are Conditional Formatting rules in place. 15 I might have clicked in column B at one point or another. 16 I'll see a drop arrow there, 17 and that just simply allows me to make a choice 18 rather than typing. 19 That's a Data Validation rule. 20 And let's say I'm familiar with those, but I'm wondering, 21 "Could there be other Data…

Contents