H
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?
moves down one row and back to the left to the first column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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
Sometimes (not often) you need to also use Format |Cells | Alignment and
check Warp Text
best wishes
H
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.
inside the cell.
it will not drop one row and return to the beginning.
B
Bernard Liengme
You could type the first part of the entry, press down arrow, type the
second part
second part
M
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
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
G
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
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
H
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.
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.
C
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.
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.