carrage return

[hary]

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?

 

[Bernard Liengme]

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

 

[hary]

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]

You could type the first part of the entry, press down arrow, type the
second part

 

[Mike Fogleman]

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

 

[Gord Dibben]

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

 

[hary]

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.

 

[Carl Hartness]

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.