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.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Basically, we start out with massive amounts of data.
How we're going to analyze this. Well, let's fire up a pivot table.
Let's see if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
What a cool trick, that I picked up at a seminar last week.
I was doing a seminar at a company called BCG, and I was showing something about data entry here.
So, if we would enter the number 1 and press tab, and then 2, Tab 3, Tab 4 and now, I'm in the last column.
If I would press enter at this point, it'll jump back to the column in which I first started.
So, that's cool, but I always complain that if I make a mistake and use the left arrow key to go back to the column in which I made a mistake correct it.
Now, Tab to column E and press Enter, rather than jumping back to the original column, column B.
It jumps back to the column in which I made the mistake.
So, I always kind of hate that method.
Someone named Chris, at that seminar raised the hand, wait a second now, there's a way to do this.
So, we do 11 Tab, 12 Tab, 14 Tab and you realize you made a mistake.
Well, she says don't use the left arrow key, use Shift+Tab to go back 13, Tab 14 and now, press Enter and Excel will preserve the original column.
So, when you make a mistake using this technique the cool thing to do is, use Shift+Tab to have to go back and Excel can still gel back to the original column.
Cool way to go.
Oh hey, I want to thank you for stopping by.
See you next time for another netcast from MrExcel.
Thanks for stopping by.
See you next time for another netcast from MrExcel.
I'm Bill Jelen.
Basically, we start out with massive amounts of data.
How we're going to analyze this. Well, let's fire up a pivot table.
Let's see if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
What a cool trick, that I picked up at a seminar last week.
I was doing a seminar at a company called BCG, and I was showing something about data entry here.
So, if we would enter the number 1 and press tab, and then 2, Tab 3, Tab 4 and now, I'm in the last column.
If I would press enter at this point, it'll jump back to the column in which I first started.
So, that's cool, but I always complain that if I make a mistake and use the left arrow key to go back to the column in which I made a mistake correct it.
Now, Tab to column E and press Enter, rather than jumping back to the original column, column B.
It jumps back to the column in which I made the mistake.
So, I always kind of hate that method.
Someone named Chris, at that seminar raised the hand, wait a second now, there's a way to do this.
So, we do 11 Tab, 12 Tab, 14 Tab and you realize you made a mistake.
Well, she says don't use the left arrow key, use Shift+Tab to go back 13, Tab 14 and now, press Enter and Excel will preserve the original column.
So, when you make a mistake using this technique the cool thing to do is, use Shift+Tab to have to go back and Excel can still gel back to the original column.
Cool way to go.
Oh hey, I want to thank you for stopping by.
See you next time for another netcast from MrExcel.
Thanks for stopping by.
See you next time for another netcast from MrExcel.
