A great call from Georgia - how to ease the data entry when you need to enter cells in an unusual pattern. Even if your data entry cells are in a circle or other strange path, you can define a named range that will remember the sequence for entering cells. Episode 359 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Welcome to the MrExcel netcast, I'm Bill Jelen.
On last Monday's podcast, I talked about a way to ease data entry by pre-selecting the cells.
After that podcast aired, I got a great call from a fellow in Georgia with a cool new trick.
Let's listen to the calls!
“You have to skip over the first cell, and the first cell that you would enter data into would be the last cell you select.
Use the Ctrl key, and then name it, and then, when you enter data in it, will follow that path.
Whatever you want to do, circle, square, whatever, it'll go to that path, but-” OK, so now that's a really cool trick, let's try it!
The really important thing that he said at the beginning is you have to skip the first square.
So let's say, for some reason, every day I wanted to enter data in this particular weird S-shaped section of cells, I'm going to skip the first.
So I'm going to select the second cell, and then hold down the Ctrl key, and in order, select the cells that I would like to enter.
So let's say, for some reason, I need to enter cells in this particular order, and it really is order dependent, you have to remember which order to select them.
Otherwise the trick, later, we'll go back to this exact same sequence.
Now, once I get to the last cell, the most important thing is to select the first cell in the list.
Now, go to our name box and say MyDataRange, hit Enter, OK.
And then tomorrow we open this worksheet, we go to the name box, select MyDataRange, and now I’m going to enter numbers.
123, Enter, 1, 1, 1, and it's going to remember the sequence, and go exactly through that order.
So, now I don't know why you would have to have to enter data in an S-shape.
But let's say you have some sort of a form, where you were going from cell to cell to cell, and you needed it to go in a particular order.
Selecting the named range is a much easier way to go, so, thanks for the call, that was a great idea!
Again, here's another one that I'll make sure to use in my future power seminars, and will have to include in a book.
Setting up a named range for your non-contiguous cells, great idea!
Stop by tomorrow for another netcast from MrExcel!
On last Monday's podcast, I talked about a way to ease data entry by pre-selecting the cells.
After that podcast aired, I got a great call from a fellow in Georgia with a cool new trick.
Let's listen to the calls!
“You have to skip over the first cell, and the first cell that you would enter data into would be the last cell you select.
Use the Ctrl key, and then name it, and then, when you enter data in it, will follow that path.
Whatever you want to do, circle, square, whatever, it'll go to that path, but-” OK, so now that's a really cool trick, let's try it!
The really important thing that he said at the beginning is you have to skip the first square.
So let's say, for some reason, every day I wanted to enter data in this particular weird S-shaped section of cells, I'm going to skip the first.
So I'm going to select the second cell, and then hold down the Ctrl key, and in order, select the cells that I would like to enter.
So let's say, for some reason, I need to enter cells in this particular order, and it really is order dependent, you have to remember which order to select them.
Otherwise the trick, later, we'll go back to this exact same sequence.
Now, once I get to the last cell, the most important thing is to select the first cell in the list.
Now, go to our name box and say MyDataRange, hit Enter, OK.
And then tomorrow we open this worksheet, we go to the name box, select MyDataRange, and now I’m going to enter numbers.
123, Enter, 1, 1, 1, and it's going to remember the sequence, and go exactly through that order.
So, now I don't know why you would have to have to enter data in an S-shape.
But let's say you have some sort of a form, where you were going from cell to cell to cell, and you needed it to go in a particular order.
Selecting the named range is a much easier way to go, so, thanks for the call, that was a great idea!
Again, here's another one that I'll make sure to use in my future power seminars, and will have to include in a book.
Setting up a named range for your non-contiguous cells, great idea!
Stop by tomorrow for another netcast from MrExcel!
