If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SPRDSHEET QUESTION
I know it must be simple answer:
when entering data in a spreadsheet for Windows ME and I depress "Enter" key to return to Column "A". It goes to only "Column B". Thanks for your help |
#2
|
|||
|
|||
SPRDSHEET QUESTION
GLEN wrote:
I know it must be simple answer: when entering data in a spreadsheet for Windows ME and I depress "Enter" key to return to Column "A". It goes to only "Column B". Thanks for your help It's supposed to go to Column B. Then if you enter info for column B it goes to Column C... etc. it's called "data entry". Unless you mean you enter the stuff for column A and the stuff gets written to column B... now that's wrong. Rick |
#3
|
|||
|
|||
SPRDSHEET QUESTION
-----Original Message----- GLEN wrote: I know it must be simple answer: when entering data in a spreadsheet for Windows ME and I depress "Enter" key to return to Column "A". It goes to only "Column B". Thanks for your help It's supposed to go to Column B. Then if you enter info for column B it goes to Column C... etc. it's called "data entry". Unless you mean you enter the stuff for column A and the stuff gets written to column B... now that's wrong. Rick . Thank you - I would like to enter data into column "B", and click on the "return" key and return to column "A" for another row of entries. But my return key does not return to the first part of the spreadsheet but goes down one row instead of the first column. |
#4
|
|||
|
|||
SPRDSHEET QUESTION
You might try reading the documentation on whatever spreadsheet package
it is you're using. Would be much more useful than I could. Rick wrote: -----Original Message----- GLEN wrote: I know it must be simple answer: when entering data in a spreadsheet for Windows ME and I depress "Enter" key to return to Column "A". It goes to only "Column B". Thanks for your help It's supposed to go to Column B. Then if you enter info for column B it goes to Column C... etc. it's called "data entry". Unless you mean you enter the stuff for column A and the stuff gets written to column B... now that's wrong. Rick . Thank you - I would like to enter data into column "B", and click on the "return" key and return to column "A" for another row of entries. But my return key does not return to the first part of the spreadsheet but goes down one row instead of the first column. |
#5
|
|||
|
|||
SPRDSHEET QUESTION
As Rick implies, it *may* depend on the application.
FWIW - on my machine, with Excel:- start in A1, tab (along) several cells and press return. Reverts to A2 but with MS Works 2000:- start in A1, tab (along) several cells and press return. Reverts to Last Used Column2 Don't know if there is any way of changing that behaviour. Mart wrote in message ... -----Original Message----- GLEN wrote: I know it must be simple answer: when entering data in a spreadsheet for Windows ME and I depress "Enter" key to return to Column "A". It goes to only "Column B". Thanks for your help It's supposed to go to Column B. Then if you enter info for column B it goes to Column C... etc. it's called "data entry". Unless you mean you enter the stuff for column A and the stuff gets written to column B... now that's wrong. Rick . Thank you - I would like to enter data into column "B", and click on the "return" key and return to column "A" for another row of entries. But my return key does not return to the first part of the spreadsheet but goes down one row instead of the first column. |
#6
|
|||
|
|||
SPRDSHEET QUESTION
There is - at least in later versions of Excel......
Tools|Options|Edit select your preference there -- Noel Paton (MS-MVP 2002-2004, Win9x) Nil Carborundum Illegitemi http://www.btinternet.com/~winnoel/millsrpch.htm Please read http://dts-l.org/goodpost.htm on how to post messages to NG's or http://www.microsoft.com/presspass/f.../Mar27pmvp.asp "Mart" wrote in message ... As Rick implies, it *may* depend on the application. FWIW - on my machine, with Excel:- start in A1, tab (along) several cells and press return. Reverts to A2 but with MS Works 2000:- start in A1, tab (along) several cells and press return. Reverts to Last Used Column2 Don't know if there is any way of changing that behaviour. Mart wrote in message ... -----Original Message----- GLEN wrote: I know it must be simple answer: when entering data in a spreadsheet for Windows ME and I depress "Enter" key to return to Column "A". It goes to only "Column B". Thanks for your help It's supposed to go to Column B. Then if you enter info for column B it goes to Column C... etc. it's called "data entry". Unless you mean you enter the stuff for column A and the stuff gets written to column B... now that's wrong. Rick . Thank you - I would like to enter data into column "B", and click on the "return" key and return to column "A" for another row of entries. But my return key does not return to the first part of the spreadsheet but goes down one row instead of the first column. |
#7
|
|||
|
|||
SPRDSHEET QUESTION
Hi Noel, I'm not sure if that's THE answer. My understanding was that the OP
wanted to return to columnA, next row down. The 'Down' option in Excel not only allows: start in A1, tab (along) several cells and press return. Reverts to A2 but also e.g. start in D4, tab (along) several cells and press return. Reverts to D5 The 'Up' has a 'similar'(ish) property, whereas Left and Right just move left and right. But Works has an option to switch the Return option on or off and when it's on, it just moves down to the next cell. When it's off, it does nothing. HTH Mart "Noel Paton" wrote in message ... There is - at least in later versions of Excel...... Tools|Options|Edit select your preference there -- Noel Paton (MS-MVP 2002-2004, Win9x) Nil Carborundum Illegitemi http://www.btinternet.com/~winnoel/millsrpch.htm Please read http://dts-l.org/goodpost.htm on how to post messages to NG's or http://www.microsoft.com/presspass/f.../Mar27pmvp.asp "Mart" wrote in message ... As Rick implies, it *may* depend on the application. FWIW - on my machine, with Excel:- start in A1, tab (along) several cells and press return. Reverts to A2 but with MS Works 2000:- start in A1, tab (along) several cells and press return. Reverts to Last Used Column2 Don't know if there is any way of changing that behaviour. Mart wrote in message ... -----Original Message----- GLEN wrote: I know it must be simple answer: when entering data in a spreadsheet for Windows ME and I depress "Enter" key to return to Column "A". It goes to only "Column B". Thanks for your help It's supposed to go to Column B. Then if you enter info for column B it goes to Column C... etc. it's called "data entry". Unless you mean you enter the stuff for column A and the stuff gets written to column B... now that's wrong. Rick . Thank you - I would like to enter data into column "B", and click on the "return" key and return to column "A" for another row of entries. But my return key does not return to the first part of the spreadsheet but goes down one row instead of the first column. |
#8
|
|||
|
|||
SPRDSHEET QUESTION
with Excel, the focus remains with the active cell - and hitting [Return]
does the action requested *from that cell* (which is not necessarily where the cursor is) e.g. In D4... type "=A3+" without the quotes click on G5 the apparent focus is G5 - but the true focus is still D4 Hit Return on default settings, the focus will move to D5 -- Noel Paton (MS-MVP 2002-2004, Win9x) Nil Carborundum Illegitemi http://www.btinternet.com/~winnoel/millsrpch.htm Please read http://dts-l.org/goodpost.htm on how to post messages to NG's or http://www.microsoft.com/presspass/f.../Mar27pmvp.asp "Mart" wrote in message ... Hi Noel, I'm not sure if that's THE answer. My understanding was that the OP wanted to return to columnA, next row down. The 'Down' option in Excel not only allows: start in A1, tab (along) several cells and press return. Reverts to A2 but also e.g. start in D4, tab (along) several cells and press return. Reverts to D5 The 'Up' has a 'similar'(ish) property, whereas Left and Right just move left and right. But Works has an option to switch the Return option on or off and when it's on, it just moves down to the next cell. When it's off, it does nothing. HTH Mart "Noel Paton" wrote in message ... There is - at least in later versions of Excel...... Tools|Options|Edit select your preference there -- Noel Paton (MS-MVP 2002-2004, Win9x) Nil Carborundum Illegitemi http://www.btinternet.com/~winnoel/millsrpch.htm Please read http://dts-l.org/goodpost.htm on how to post messages to NG's or http://www.microsoft.com/presspass/f.../Mar27pmvp.asp "Mart" wrote in message ... As Rick implies, it *may* depend on the application. FWIW - on my machine, with Excel:- start in A1, tab (along) several cells and press return. Reverts to A2 but with MS Works 2000:- start in A1, tab (along) several cells and press return. Reverts to Last Used Column2 Don't know if there is any way of changing that behaviour. Mart wrote in message ... -----Original Message----- GLEN wrote: I know it must be simple answer: when entering data in a spreadsheet for Windows ME and I depress "Enter" key to return to Column "A". It goes to only "Column B". Thanks for your help It's supposed to go to Column B. Then if you enter info for column B it goes to Column C... etc. it's called "data entry". Unless you mean you enter the stuff for column A and the stuff gets written to column B... now that's wrong. Rick . Thank you - I would like to enter data into column "B", and click on the "return" key and return to column "A" for another row of entries. But my return key does not return to the first part of the spreadsheet but goes down one row instead of the first column. |
#9
|
|||
|
|||
SPRDSHEET QUESTION
Mmm.. but not too sure if that was the OP's dilemma. I suspect his problem
was far more basic than that g Mart "Noel Paton" wrote in message ... with Excel, the focus remains with the active cell - and hitting [Return] does the action requested *from that cell* (which is not necessarily where the cursor is) e.g. In D4... type "=A3+" without the quotes click on G5 the apparent focus is G5 - but the true focus is still D4 Hit Return on default settings, the focus will move to D5 -- Noel Paton (MS-MVP 2002-2004, Win9x) Nil Carborundum Illegitemi http://www.btinternet.com/~winnoel/millsrpch.htm Please read http://dts-l.org/goodpost.htm on how to post messages to NG's or http://www.microsoft.com/presspass/f.../Mar27pmvp.asp "Mart" wrote in message ... Hi Noel, I'm not sure if that's THE answer. My understanding was that the OP wanted to return to columnA, next row down. The 'Down' option in Excel not only allows: start in A1, tab (along) several cells and press return. Reverts to A2 but also e.g. start in D4, tab (along) several cells and press return. Reverts to D5 The 'Up' has a 'similar'(ish) property, whereas Left and Right just move left and right. But Works has an option to switch the Return option on or off and when it's on, it just moves down to the next cell. When it's off, it does nothing. HTH Mart "Noel Paton" wrote in message ... There is - at least in later versions of Excel...... Tools|Options|Edit select your preference there -- Noel Paton (MS-MVP 2002-2004, Win9x) Nil Carborundum Illegitemi http://www.btinternet.com/~winnoel/millsrpch.htm Please read http://dts-l.org/goodpost.htm on how to post messages to NG's or http://www.microsoft.com/presspass/f.../Mar27pmvp.asp "Mart" wrote in message ... As Rick implies, it *may* depend on the application. FWIW - on my machine, with Excel:- start in A1, tab (along) several cells and press return. Reverts to A2 but with MS Works 2000:- start in A1, tab (along) several cells and press return. Reverts to Last Used Column2 Don't know if there is any way of changing that behaviour. Mart wrote in message ... -----Original Message----- GLEN wrote: I know it must be simple answer: when entering data in a spreadsheet for Windows ME and I depress "Enter" key to return to Column "A". It goes to only "Column B". Thanks for your help It's supposed to go to Column B. Then if you enter info for column B it goes to Column C... etc. it's called "data entry". Unless you mean you enter the stuff for column A and the stuff gets written to column B... now that's wrong. Rick . Thank you - I would like to enter data into column "B", and click on the "return" key and return to column "A" for another row of entries. But my return key does not return to the first part of the spreadsheet but goes down one row instead of the first column. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
another question | Improving Performance | 1 | July 21st 04 12:09 PM | |
Norton AV renewal question | Gianni | General | 26 | June 28th 04 10:05 PM |
Memory question | John Callaway | Improving Performance | 2 | June 16th 04 03:39 AM |
250gB Hard Disk Format Question | Malcolm Dowers | Disk Drives | 1 | June 2nd 04 01:50 AM |
Id53 error message...another question | Sjohnson | General | 3 | May 19th 04 05:35 AM |