Join Dennis Taylor for an in-depth discussion in this video Discovering time-saving tools in the Go To Special feature, part of Excel Tips Weekly.
- On the Home tab in the ribbon, the far right button…in the Editing group is called Find & Select…and lots of interesting choices and viable choices here…including one called Go To Special.…I've depicted the Go To Special dialog box on this worksheet…off to the left.…A number of these choices here are available by way…of keystroke shortcuts and a number of them…are also available by some of the choices that we see…on Find & Select.…So let's take a look at some of these options here.…I'm going to go to first worksheet in this workbook…and imagine that I'm interested in seeing…where the comments are.…
Now I can see the red triangles here,…imagine the worksheet possibly is much larger.…I might want to simply highlight all of these.…By going to Find & Select and Go To Special,…the first choice says Comments.…Click OK.…All the comments cells are highlighted.…Do recognize when cells are highlighted,…one of them appears not to have a gray background.…But cell D2 is part of the mix here.…If you somehow wanted to note that or keep track of that…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
Freeze Panes and Split New5m 30s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.