Use the SHIFT key on your keyboard to select data between two cells. Combining it with the CTRL key at the same time makes for a dynamic duo that lets you quickly select ranges for further analysis or action.
Thanks for stopping by!
p.s. You can check out other posts on the Blog feed or Sign up to be notified when the next post is available.
3 Comments
Mariana Trapnell
March 5, 2017Rhonda Walker: I use shift and ctrl a lot in Word. I hadn’t known, though, that in Excel it takes you to the next blank area or next populated area, so thanks for pointing that out.
I wouldn’t have dreamed that CTRL-A doesn’t necessarily grab all your data – that was a really important distinction to make! Thanks 🙂
Mariana: Yup, Excel’s helpful, but you definitely need to double-check what it does. 🙂
Mariana Trapnell
March 5, 2017Hey! I’m making a change to the blog to display only one Comments section and I’ll actually get notified when a comment is made. Unfortunately, that means previous comments made via Facebook will be removed. So that we don’t lose the information, I’ve copied them below. Thanks for joining in! Sharing knowledge is what this blog is all about, so it’s great when you take the time to share your knowledge too!
Ryan
September 15, 2016Great work! A lot of people will become more efficient at excel after watching these videos. In addition to Ctrl+A, users can use Ctrl+Shift+Spacebar. Just another way to remember!
Leave A Response
You must be logged in to post a comment.