A Windows 98 & ME forum. Win98banter

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.

Go Back   Home » Win98banter forum » Windows ME » Software & Applications
Site Map Home Authors List Search Today's Posts Mark Forums Read Web Partners

SPRDSHEET QUESTION



 
 
Thread Tools Display Modes
  #1  
Old May 29th 04, 04:59 PM
GLEN
external usenet poster
 
Posts: n/a
Default 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  
Old May 29th 04, 05:12 PM
Rick T
external usenet poster
 
Posts: n/a
Default 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  
Old May 29th 04, 05:15 PM
external usenet poster
 
Posts: n/a
Default 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.
  #5  
Old May 29th 04, 10:05 PM
Mart
external usenet poster
 
Posts: n/a
Default 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  
Old May 29th 04, 10:21 PM
Noel Paton
external usenet poster
 
Posts: n/a
Default 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  
Old May 30th 04, 01:42 AM
Mart
external usenet poster
 
Posts: n/a
Default 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  
Old May 30th 04, 09:40 AM
Noel Paton
external usenet poster
 
Posts: n/a
Default 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  
Old May 30th 04, 10:48 AM
Mart
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Win98banter.
The comments are property of their posters.