SHIFT into high gear on your Excel analysis

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, 2017

    Rhonda 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, 2017

    Hey! 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, 2016

    Great 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