How To Jump to the Last Cell in a Selected Range - Excel Campus
3

How To Jump to the Last Cell in a Selected Range

Have you ever pasted a long list of data, and then wondered if you completely pasted over the existing data?

In the following video I explain how to use the keyboard shortcut Ctrl+. (period) to quickly answer this question.  It’s one of my favorite keyboard shortcuts because it can save you from having to scroll hundreds or thousands of rows with the mouse.

Paste Data Over Existing Data

Note: The Ctrl+. shortcut also works on the Mac version of Excel.

Video

Watch the video on YouTube

More Videos Like This – Video Series

Navigate Excel with the Keyboard Video Course

This video is part of a 6-part video series on “How to Navigate Excel with the Keyboard”.  This series is an introduction to basic keyboard shortcuts that will help you:

  • Quickly select cells and ranges to save time with copy/paste or entering formulas.
  • Navigate through the worksheets in the workbook.
  • Learn shortcuts for the Excel ribbon (toolbar) to quickly perform commands you use the most.

eBook – The Companion to the Video Series

Navigate Excel with the Keyboard eBook

I have also written an eBook on this topic with detailed step-by-step tutorials.  The book also explains “why” it is so important to learn keyboard shortcuts in Excel.  Using a combination of the keyboard and mouse can help you work very efficiently in Excel.

The key to learning keyboard shortcuts is to take your time and practice.  You can’t expect to memorize shortcut keys overnight, and this book gives you a good understanding of the basics.

A Page from the Book

Here is a sample page from the book that explains another shortcut to add or delete rows.  This is another shortcut that will save you a lot of time.

Sample Page from Navigate Excel with the Keyboard eBook-13

Click to Enlarge

Get the Video Series and eBook for FREE!

For a limited time I’m giving the entire video series and eBook away as a bonus when you purchase the Tab Hound add-in.  I am also including the Tab Control add-in for free.  So you will receive a lot of great bonuses that will help you learn Excel and get your job done faster!

The offer expires on August 15th, so get it before it’s too late.

Tab Hound and Tab Control Logo

Download Button

Click here to get Tab Hound, Tab Control, the video series, and the eBook.

What Do You Think?

Please leave a comment below with any questions about the tips on this page.  Thank you! 🙂

Please share
Jon Acampora
 

Welcome to Excel Campus! I am excited you are here. My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career. I've been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP. I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I'm not looking at spreadsheets, I get outdoors and surf. :) more about me

Click Here to Leave a Comment Below 3 comments
John Atamanczyk - April 27, 2017

I do love this shortcut and use it all the time, although I’m not sure I would use it in the situation that was illustrated.

If you want to make sure all of your old data is gone, why not delete everything out of that worksheet first, so you have a clean worksheet on which to paste the new data?

Reply
Jon Acampora - November 20, 2014

Thanks Dave! It definitely helps prevent a sore scrolling finger… 🙂

Reply
Dave Bruns - November 8, 2014

Hey John, excellent tip & video! When you’re working with hundreds or thousands of rows, controlling the location of the active cell in a selection is huge. Like you say, it can save *a lot* of scrolling.

Reply

Leave a Reply:

Take Your Excel Skills & Career to the Next Level

10 Excel Pro Tips eBook

Get my eBook & FREE weekly updates to help you learn Excel.

x