Home |
Search |
Today's Posts |
#1
|
|||
|
|||
go from last column to first column, next row?
I knnow there is a way to "teach" my spreadsheet the range I am entering data
into. But I don't remember how. The actice cell is supposed to go from the last data entry column in the current row, to the first column in the next row. All I had to do was hit "Enter" and I was ready to enter the next record. Does anybody remember how? |
#2
|
|||
|
|||
QA Guy,
You need to select all the cells first. And your movement after entry need to be set to move to the right. Or, you could use a selection change event, but that is much more complicated. HTH, Bernie MS Excel MVP "QAguy" wrote in message ... I knnow there is a way to "teach" my spreadsheet the range I am entering data into. But I don't remember how. The actice cell is supposed to go from the last data entry column in the current row, to the first column in the next row. All I had to do was hit "Enter" and I was ready to enter the next record. Does anybody remember how? |
#3
|
|||
|
|||
Bernie,
That did help some, and is along the lines of what I used to be able to do. And it cetainly did not involve 'events' or ScaryQuirkyLanguage (SQL). But your way the cells stayed selected, and each time I clicked in a cell I had to re-select the range AND 'enter' my way through ALL the records and columns to get back to where I was entering info. Maybe my memory is bad, but I could have sworn there was a way to get the same results WITHOUT the white on black of selected cells. Would it work if I 'named' the range? "Bernie Deitrick" wrote: QA Guy, You need to select all the cells first. And your movement after entry need to be set to move to the right. Or, you could use a selection change event, but that is much more complicated. HTH, Bernie MS Excel MVP "QAguy" wrote in message ... I knnow there is a way to "teach" my spreadsheet the range I am entering data into. But I don't remember how. The actice cell is supposed to go from the last data entry column in the current row, to the first column in the next row. All I had to do was hit "Enter" and I was ready to enter the next record. Does anybody remember how? |
#4
|
|||
|
|||
QAguy, how about unlocking the cells you want to enter data in and then
protecting the sheet, select only unlocked cells, will that work? Other wise I think you would need some VBA as Bernie said -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "QAguy" wrote in message ... Bernie, That did help some, and is along the lines of what I used to be able to do. And it cetainly did not involve 'events' or ScaryQuirkyLanguage (SQL). But your way the cells stayed selected, and each time I clicked in a cell I had to re-select the range AND 'enter' my way through ALL the records and columns to get back to where I was entering info. Maybe my memory is bad, but I could have sworn there was a way to get the same results WITHOUT the white on black of selected cells. Would it work if I 'named' the range? "Bernie Deitrick" wrote: QA Guy, You need to select all the cells first. And your movement after entry need to be set to move to the right. Or, you could use a selection change event, but that is much more complicated. HTH, Bernie MS Excel MVP "QAguy" wrote in message ... I knnow there is a way to "teach" my spreadsheet the range I am entering data into. But I don't remember how. The actice cell is supposed to go from the last data entry column in the current row, to the first column in the next row. All I had to do was hit "Enter" and I was ready to enter the next record. Does anybody remember how? |
#5
|
|||
|
|||
Assuming you start entering data in column A and want to go across to
F1......... Use the TAB key when leaving A1 to go to B1 then C1, D1, E1, F1 as you enter the data. When leaving F1, hit the <ENTER key to drop to A2. The <ENTER key will drop down 1 row and go back to the column in which you started. Gord Dibben Excel MVP On Thu, 20 Jan 2005 07:51:15 -0800, "QAguy" wrote: I knnow there is a way to "teach" my spreadsheet the range I am entering data into. But I don't remember how. The actice cell is supposed to go from the last data entry column in the current row, to the first column in the next row. All I had to do was hit "Enter" and I was ready to enter the next record. Does anybody remember how? |
#6
|
|||
|
|||
THAT'S IT ! Thank you all. As soon as I switched 'Move selection after
Enter" back to Down, the TAB method worked perfectly. I knew it was a simple skill I had forgotten. Gord, thanks again. BTW, it is A1 to AG1, which is why I was desparate to remember your solution. :-) "Gord Dibben" wrote: Assuming you start entering data in column A and want to go across to F1......... Use the TAB key when leaving A1 to go to B1 then C1, D1, E1, F1 as you enter the data. When leaving F1, hit the <ENTER key to drop to A2. The <ENTER key will drop down 1 row and go back to the column in which you started. Gord Dibben Excel MVP On Thu, 20 Jan 2005 07:51:15 -0800, "QAguy" wrote: I knnow there is a way to "teach" my spreadsheet the range I am entering data into. But I don't remember how. The actice cell is supposed to go from the last data entry column in the current row, to the first column in the next row. All I had to do was hit "Enter" and I was ready to enter the next record. Does anybody remember how? |
#7
|
|||
|
|||
Thanks for the feedback.
A1 to AG1 is a long way to run. Gord On Thu, 20 Jan 2005 10:27:04 -0800, "QAguy" wrote: THAT'S IT ! Thank you all. As soon as I switched 'Move selection after Enter" back to Down, the TAB method worked perfectly. I knew it was a simple skill I had forgotten. Gord, thanks again. BTW, it is A1 to AG1, which is why I was desparate to remember your solution. :-) "Gord Dibben" wrote: Assuming you start entering data in column A and want to go across to F1......... Use the TAB key when leaving A1 to go to B1 then C1, D1, E1, F1 as you enter the data. When leaving F1, hit the <ENTER key to drop to A2. The <ENTER key will drop down 1 row and go back to the column in which you started. Gord Dibben Excel MVP On Thu, 20 Jan 2005 07:51:15 -0800, "QAguy" wrote: I knnow there is a way to "teach" my spreadsheet the range I am entering data into. But I don't remember how. The actice cell is supposed to go from the last data entry column in the current row, to the first column in the next row. All I had to do was hit "Enter" and I was ready to enter the next record. Does anybody remember how? |
#8
|
|||
|
|||
I was wondering how do you set the spreadsheet to move from one column to the
next after your cells are password protected? For example, I want in set the spreadsheet for input of data from Cells A10 thru A20 and then go to B10 and input data down to B20. I want to do this by using the enter key or the tab key. Any suggestions? Thanks "Gord Dibben" wrote: Thanks for the feedback. A1 to AG1 is a long way to run. Gord On Thu, 20 Jan 2005 10:27:04 -0800, "QAguy" wrote: THAT'S IT ! Thank you all. As soon as I switched 'Move selection after Enter" back to Down, the TAB method worked perfectly. I knew it was a simple skill I had forgotten. Gord, thanks again. BTW, it is A1 to AG1, which is why I was desparate to remember your solution. :-) "Gord Dibben" wrote: Assuming you start entering data in column A and want to go across to F1......... Use the TAB key when leaving A1 to go to B1 then C1, D1, E1, F1 as you enter the data. When leaving F1, hit the <ENTER key to drop to A2. The <ENTER key will drop down 1 row and go back to the column in which you started. Gord Dibben Excel MVP On Thu, 20 Jan 2005 07:51:15 -0800, "QAguy" wrote: I knnow there is a way to "teach" my spreadsheet the range I am entering data into. But I don't remember how. The actice cell is supposed to go from the last data entry column in the current row, to the first column in the next row. All I had to do was hit "Enter" and I was ready to enter the next record. Does anybody remember how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |