Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
How can I get the cursor to go down one line AND return to its original
column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Select A1 then Tab your way across row 1 as you enter data.
When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Thank you for your response but my Excel 2007 is not doing that - it is only
going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
I have not yet upgraded to 2007 so can't test.
The Tab, Tab, Tab then ENTER works with earlier versions. Perhaps a 2007 user can confirm the method works or not. Gord On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior wrote: Thank you for your response but my Excel 2007 is not doing that - it is only going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Hi Gord
Yes everything does still work the same as earlier versions. Tab, Tab, Tab Enter would go A1, B1, C1 A2 To the OP, are you sure you are using the TAB key, not the right arrow key or Enter as you progress across the page before you hit Enter? -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I have not yet upgraded to 2007 so can't test. The Tab, Tab, Tab then ENTER works with earlier versions. Perhaps a 2007 user can confirm the method works or not. Gord On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior wrote: Thank you for your response but my Excel 2007 is not doing that - it is only going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Thanks Roger.
Gord On Fri, 30 Mar 2007 00:35:42 +0100, "Roger Govier" wrote: Hi Gord Yes everything does still work the same as earlier versions. Tab, Tab, Tab Enter would go A1, B1, C1 A2 To the OP, are you sure you are using the TAB key, not the right arrow key or Enter as you progress across the page before you hit Enter? |
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Okay - this is only happening in a protected Worksheet - is there a way
around this to get the cursor to respond the same as if the worksheet was not protected? I am only experiencing this in Excel 2007 "Roger Govier" wrote: Hi Gord Yes everything does still work the same as earlier versions. Tab, Tab, Tab Enter would go A1, B1, C1 A2 To the OP, are you sure you are using the TAB key, not the right arrow key or Enter as you progress across the page before you hit Enter? -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I have not yet upgraded to 2007 so can't test. The Tab, Tab, Tab then ENTER works with earlier versions. Perhaps a 2007 user can confirm the method works or not. Gord On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior wrote: Thank you for your response but my Excel 2007 is not doing that - it is only going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#8
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
And yes - definitely using the tab key - it is a form that has two columns of
numbers to be entered (A & B) - a forumula exists in column c (cells locked) a selection is made from a drop down list in column d, Columns e & f have formulas (vlookup) dependent upon the drop down list for column d and tables created on a separate worksheets. When formulas are unprotected - the cursor works fine. Protected - the tab works great (skipping the procted cells and going directly to the input cells) but when hitting the "Enter" key, it only goes down one row (not back to the original input column) "Roger Govier" wrote: Hi Gord Yes everything does still work the same as earlier versions. Tab, Tab, Tab Enter would go A1, B1, C1 A2 To the OP, are you sure you are using the TAB key, not the right arrow key or Enter as you progress across the page before you hit Enter? -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I have not yet upgraded to 2007 so can't test. The Tab, Tab, Tab then ENTER works with earlier versions. Perhaps a 2007 user can confirm the method works or not. Gord On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior wrote: Thank you for your response but my Excel 2007 is not doing that - it is only going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#9
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Hi
I have just set up a sheet. I unlocked columns A,B,C and F,G,H I protected the sheet. Starting in A1 Tab, Tab, Tab, Tab, Tab, Enter moves the active cell to B1, C1, F1, G1, H1, A2 B2, C2, F2, G2, H2, A3 for me with XL2007 on Windows XP Professional. If you are still having a problem, send me a copy of the file. To send direct, remove NOSPAM from my address. -- Regards Roger Govier "skrappySenior" wrote in message ... And yes - definitely using the tab key - it is a form that has two columns of numbers to be entered (A & B) - a forumula exists in column c (cells locked) a selection is made from a drop down list in column d, Columns e & f have formulas (vlookup) dependent upon the drop down list for column d and tables created on a separate worksheets. When formulas are unprotected - the cursor works fine. Protected - the tab works great (skipping the procted cells and going directly to the input cells) but when hitting the "Enter" key, it only goes down one row (not back to the original input column) "Roger Govier" wrote: Hi Gord Yes everything does still work the same as earlier versions. Tab, Tab, Tab Enter would go A1, B1, C1 A2 To the OP, are you sure you are using the TAB key, not the right arrow key or Enter as you progress across the page before you hit Enter? -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I have not yet upgraded to 2007 so can't test. The Tab, Tab, Tab then ENTER works with earlier versions. Perhaps a 2007 user can confirm the method works or not. Gord On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior wrote: Thank you for your response but my Excel 2007 is not doing that - it is only going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#10
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Glood morning Roger - what options did you choose for the protection of the
sheet? I do not have 2007 on this computer and file is at client site or I would gladly send you the file. "Roger Govier" wrote: Hi I have just set up a sheet. I unlocked columns A,B,C and F,G,H I protected the sheet. Starting in A1 Tab, Tab, Tab, Tab, Tab, Enter moves the active cell to B1, C1, F1, G1, H1, A2 B2, C2, F2, G2, H2, A3 for me with XL2007 on Windows XP Professional. If you are still having a problem, send me a copy of the file. To send direct, remove NOSPAM from my address. -- Regards Roger Govier "skrappySenior" wrote in message ... And yes - definitely using the tab key - it is a form that has two columns of numbers to be entered (A & B) - a forumula exists in column c (cells locked) a selection is made from a drop down list in column d, Columns e & f have formulas (vlookup) dependent upon the drop down list for column d and tables created on a separate worksheets. When formulas are unprotected - the cursor works fine. Protected - the tab works great (skipping the procted cells and going directly to the input cells) but when hitting the "Enter" key, it only goes down one row (not back to the original input column) "Roger Govier" wrote: Hi Gord Yes everything does still work the same as earlier versions. Tab, Tab, Tab Enter would go A1, B1, C1 A2 To the OP, are you sure you are using the TAB key, not the right arrow key or Enter as you progress across the page before you hit Enter? -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I have not yet upgraded to 2007 so can't test. The Tab, Tab, Tab then ENTER works with earlier versions. Perhaps a 2007 user can confirm the method works or not. Gord On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior wrote: Thank you for your response but my Excel 2007 is not doing that - it is only going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#11
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Hi
I didn't select any options, just took the default. Didn't give any password. When I say I unlocked the columns, I meant that I selected those columns, FormatCellsProtectiontook the tick out of Locked. I have all versions of XL from 97 to 2007 on my machine, and the behaviour for 2007 I have not found in any way different with respect to the things being discussed in this thread. -- Regards Roger Govier "skrappySenior" wrote in message ... Glood morning Roger - what options did you choose for the protection of the sheet? I do not have 2007 on this computer and file is at client site or I would gladly send you the file. "Roger Govier" wrote: Hi I have just set up a sheet. I unlocked columns A,B,C and F,G,H I protected the sheet. Starting in A1 Tab, Tab, Tab, Tab, Tab, Enter moves the active cell to B1, C1, F1, G1, H1, A2 B2, C2, F2, G2, H2, A3 for me with XL2007 on Windows XP Professional. If you are still having a problem, send me a copy of the file. To send direct, remove NOSPAM from my address. -- Regards Roger Govier "skrappySenior" wrote in message ... And yes - definitely using the tab key - it is a form that has two columns of numbers to be entered (A & B) - a forumula exists in column c (cells locked) a selection is made from a drop down list in column d, Columns e & f have formulas (vlookup) dependent upon the drop down list for column d and tables created on a separate worksheets. When formulas are unprotected - the cursor works fine. Protected - the tab works great (skipping the procted cells and going directly to the input cells) but when hitting the "Enter" key, it only goes down one row (not back to the original input column) "Roger Govier" wrote: Hi Gord Yes everything does still work the same as earlier versions. Tab, Tab, Tab Enter would go A1, B1, C1 A2 To the OP, are you sure you are using the TAB key, not the right arrow key or Enter as you progress across the page before you hit Enter? -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I have not yet upgraded to 2007 so can't test. The Tab, Tab, Tab then ENTER works with earlier versions. Perhaps a 2007 user can confirm the method works or not. Gord On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior wrote: Thank you for your response but my Excel 2007 is not doing that - it is only going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#12
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Good Morning Roger,
I did exactly as you documented in your reply, with the exception of choosing the option "select non-protected cells" only - this creates the problem that I defined originally the cursor does not return to the originating column - truly it does not, but thanks for your time and consideration "Roger Govier" wrote: Hi I didn't select any options, just took the default. Didn't give any password. When I say I unlocked the columns, I meant that I selected those columns, FormatCellsProtectiontook the tick out of Locked. I have all versions of XL from 97 to 2007 on my machine, and the behaviour for 2007 I have not found in any way different with respect to the things being discussed in this thread. -- Regards Roger Govier "skrappySenior" wrote in message ... Glood morning Roger - what options did you choose for the protection of the sheet? I do not have 2007 on this computer and file is at client site or I would gladly send you the file. "Roger Govier" wrote: Hi I have just set up a sheet. I unlocked columns A,B,C and F,G,H I protected the sheet. Starting in A1 Tab, Tab, Tab, Tab, Tab, Enter moves the active cell to B1, C1, F1, G1, H1, A2 B2, C2, F2, G2, H2, A3 for me with XL2007 on Windows XP Professional. If you are still having a problem, send me a copy of the file. To send direct, remove NOSPAM from my address. -- Regards Roger Govier "skrappySenior" wrote in message ... And yes - definitely using the tab key - it is a form that has two columns of numbers to be entered (A & B) - a forumula exists in column c (cells locked) a selection is made from a drop down list in column d, Columns e & f have formulas (vlookup) dependent upon the drop down list for column d and tables created on a separate worksheets. When formulas are unprotected - the cursor works fine. Protected - the tab works great (skipping the procted cells and going directly to the input cells) but when hitting the "Enter" key, it only goes down one row (not back to the original input column) "Roger Govier" wrote: Hi Gord Yes everything does still work the same as earlier versions. Tab, Tab, Tab Enter would go A1, B1, C1 A2 To the OP, are you sure you are using the TAB key, not the right arrow key or Enter as you progress across the page before you hit Enter? -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I have not yet upgraded to 2007 so can't test. The Tab, Tab, Tab then ENTER works with earlier versions. Perhaps a 2007 user can confirm the method works or not. Gord On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior wrote: Thank you for your response but my Excel 2007 is not doing that - it is only going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
#13
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 - cursor down & left after entry - How?
Hi
Select Locked cells AND Select Unlocked cells. Then it works as described. -- Regards Roger Govier "skrappySenior" wrote in message ... Good Morning Roger, I did exactly as you documented in your reply, with the exception of choosing the option "select non-protected cells" only - this creates the problem that I defined originally the cursor does not return to the originating column - truly it does not, but thanks for your time and consideration "Roger Govier" wrote: Hi I didn't select any options, just took the default. Didn't give any password. When I say I unlocked the columns, I meant that I selected those columns, FormatCellsProtectiontook the tick out of Locked. I have all versions of XL from 97 to 2007 on my machine, and the behaviour for 2007 I have not found in any way different with respect to the things being discussed in this thread. -- Regards Roger Govier "skrappySenior" wrote in message ... Glood morning Roger - what options did you choose for the protection of the sheet? I do not have 2007 on this computer and file is at client site or I would gladly send you the file. "Roger Govier" wrote: Hi I have just set up a sheet. I unlocked columns A,B,C and F,G,H I protected the sheet. Starting in A1 Tab, Tab, Tab, Tab, Tab, Enter moves the active cell to B1, C1, F1, G1, H1, A2 B2, C2, F2, G2, H2, A3 for me with XL2007 on Windows XP Professional. If you are still having a problem, send me a copy of the file. To send direct, remove NOSPAM from my address. -- Regards Roger Govier "skrappySenior" wrote in message ... And yes - definitely using the tab key - it is a form that has two columns of numbers to be entered (A & B) - a forumula exists in column c (cells locked) a selection is made from a drop down list in column d, Columns e & f have formulas (vlookup) dependent upon the drop down list for column d and tables created on a separate worksheets. When formulas are unprotected - the cursor works fine. Protected - the tab works great (skipping the procted cells and going directly to the input cells) but when hitting the "Enter" key, it only goes down one row (not back to the original input column) "Roger Govier" wrote: Hi Gord Yes everything does still work the same as earlier versions. Tab, Tab, Tab Enter would go A1, B1, C1 A2 To the OP, are you sure you are using the TAB key, not the right arrow key or Enter as you progress across the page before you hit Enter? -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I have not yet upgraded to 2007 so can't test. The Tab, Tab, Tab then ENTER works with earlier versions. Perhaps a 2007 user can confirm the method works or not. Gord On Thu, 29 Mar 2007 12:14:01 -0700, skrappySenior wrote: Thank you for your response but my Excel 2007 is not doing that - it is only going down 1 cell - it is not returning to the original column - so if I am in column H (as in your example - when I hit return it goes to H2 "Gord Dibben" wrote: Select A1 then Tab your way across row 1 as you enter data. When you reach say, column H, hit the ENTER key to go to A2. This method will always return you to the original column(any column) you started in and one row down. Gord Dibben MS Excel MVP On Thu, 29 Mar 2007 07:00:01 -0700, skrappySenior wrote: How can I get the cursor to go down one line AND return to its original column position after data entry? I finally found the options and the selection is "Down" after entry. However, it will not return back to the first column where I started. I guess I am old, but the new 2007 is too....too much icons for me.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where on earth can I find data entry forms in Excel 2007 | Excel Discussion (Misc queries) | |||
data entry right to left | Excel Discussion (Misc queries) | |||
Text shifts left in Excel Combo Box when user types in entry | Excel Discussion (Misc queries) | |||
Cursor wil not move left in worksheet | Excel Worksheet Functions | |||
I want to add a sound event when the cursor bumps left margin | Excel Discussion (Misc queries) |