Look Who it Was Random video

Excel - Speed up Data Entry in Excel with this Cool Trick! | Excel Tutorial - Episode 1048

994 views · Published 1 July 2009 · 1:46 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Speed up Data Entry in Excel with this Cool Trick! | Excel Tutorial.

Welcome to another episode of the MrExcel netcast, where we dive into all things Excel. In this episode, we'll be discussing a cool trick that I recently learned at a seminar. But first, let's talk about the common problem we all face - massive amounts of data. How do we analyze it efficiently? Well, the answer lies in pivot tables. So, let's get started and see if you can solve this problem along with me.

During a recent seminar at BCG, I was demonstrating a data entry technique where you enter numbers in a column and press tab to move to the next column. However, I always found it frustrating that if I made a mistake and used the left arrow key to go back and correct it, Excel would jump back to the first column instead of the one I was working on. But thanks to a participant named Chris, I learned a much better way to do this. Instead of using the left arrow key, use Shift+Tab to go back and Excel will preserve the original column. This way, you can easily correct your mistake without having to start all over again.

I hope this trick will save you some time and frustration in your data entry process. And if you have any other cool Excel tips or tricks, please share them in the comments below. Thank you for tuning in to this episode of the MrExcel netcast. Don't forget to subscribe to our channel for more Excel tutorials and tips. See you next time!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction to MrExcel netcast
(00:15) Cool data entry trick
(00:36) A better way to correct mistakes
(01:13) Using Shift+Tab to preserve original column
(01:23) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Cool trick
Data analysis
Data entry
Excel preservation
Left arrow key
Mistake correction
Netcast from MrExcel
Pivot table
Seminar
Shift+Tab

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152495/



Episode 1048 will show you a cool way to speed data entry using a combination of the tab and enter keys. While I have discussed this before on the podcast, using shift-tab makes the trick a bit cooler.

More from this channel