Join Dennis Taylor for an in-depth discussion in this video Keystroke shortcuts from A to Z - using the Ctrl key, part of Excel Tips Weekly.
- [Voiceover] Excel has well over 200 keystroke shortcuts,…and there's a whole series of them starting with…control A all the way down to control Z.…Now some of these are widely used, some are not,…but it's worth a look at all of them.…Two of them are not used at all,…so there are 24 keystroke shortcuts…that we're about to talk about.…Control J and control M have no keystroke meaning.…Usually when you see these listed…at websites or in books,…you see something like control plus A,…meaning hold down the control key as you click this letter.…Control A has multiple meanings.…
If you click in an empty cell with no data around it,…control A selects the entire worksheet.…That's gonna be handy at times.…If you click where there is data,…and there might be other data on the worksheet…but separated from it,…control A means highlight all the contiguous data.…So I've clicked on cell B5, I'll press control A,…it highlights just this data.…If I want the entire worksheet highlighted,…I'll press control A again.…So if you wanted to highlight the entire worksheet…
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
- 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.