carrage return
 

can I format a cell so when the data is entered it does a carrage return and
moves down one row and back to the left to the first column?

carrage return
 

This is called 'wrapping' and is done with ALT+ENTER
Sometimes (not often) you need to also use Format |Cells | Alignment and
check Warp Text
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"hary" wrote in message
...
can I format a cell so when the data is entered it does a carrage return
and
moves down one row and back to the left to the first column?

carrage return
 

sorry but I did not achieve the results I was looking for. It only wraps
inside the cell.
it will not drop one row and return to the beginning.

"Bernard Liengme" wrote:

This is called 'wrapping' and is done with ALT+ENTER
Sometimes (not often) you need to also use Format |Cells | Alignment and
check Warp Text
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"hary" wrote in message
...
can I format a cell so when the data is entered it does a carrage return
and
moves down one row and back to the left to the first column?

carrage return
 

You could type the first part of the entry, press down arrow, type the
second part
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"hary" wrote in message
...
sorry but I did not achieve the results I was looking for. It only wraps
inside the cell.
it will not drop one row and return to the beginning.

"Bernard Liengme" wrote:

This is called 'wrapping' and is done with ALT+ENTER
Sometimes (not often) you need to also use Format |Cells | Alignment and
check Warp Text
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"hary" wrote in message
...
can I format a cell so when the data is entered it does a carrage
return
and
moves down one row and back to the left to the first column?

carrage return
 

There is no format that can be set but it can be done under certain
conditions. In Tools/Options Edit select move cursor to right after Enter.
Then select the area that you want data to be entered so that it is
highlighted. Now as you type and hit Enter the cursor will move to the right
until it gets to the end of the selected area, then move to the beginning of
the next row in the selected area.

Mike F
"hary" wrote in message
...
can I format a cell so when the data is entered it does a carrage return
and
moves down one row and back to the left to the first column?

carrage return
 

Not sure what you mean about moving down one row and back to the left in first
column but.......................maybe this.

Start in A1 and type in data. Hit Tab key to go to B1, type in data and hit Tab
to go to C1, type in data and hit ENTER key to go back to column A one row down
to A2.

Make sure ENTER key "move selection after Enter" is set to "down"



Gord Dibben MS Excel MVP


On Mon, 10 Dec 2007 13:29:00 -0800, hary wrote:

can I format a cell so when the data is entered it does a carrage return and
moves down one row and back to the left to the first column?

carrage return
 

thank you for all the suggestions
but it seems what I am trying to pull off my not work
I have a bar code scanner, and each time I scan a bar it enters it into a cell
then moves one cell to the right. I have five columns, what I wanted it to do
was when it reached the fifth column and the data was entered was to start
over with the first column again.

"hary" wrote:

can I format a cell so when the data is entered it does a carrage return and
moves down one row and back to the left to the first column?

carrage return
 

In the class module for the sheet where you want this to happen, enter
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 6 Then Target.Offset(1, -5).Activate
End Sub

In conjunction with Options - Edit - Move selection after Enter -
Right,
this will allow you to enter in columns A through E.

Adjust Target.Column if you want some other set of 5 columns.

Carl.

On Dec 11, 9:31 am, hary wrote:
thank you for all the suggestions
but it seems what I am trying to pull off my not work
I have a bar code scanner, and each time I scan a bar it enters it into a cell
then moves one cell to the right. I have five columns, what I wanted it to do
was when it reached the fifth column and the data was entered was to start
over with the first column again.



"hary" wrote:
can I format a cell so when the data is entered it does a carrage return and
moves down one row and back to the left to the first column?- Hide quoted text -

- Show quoted text -