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?

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" <(E-Mail Removed)> wrote in message
news383BCFB-9080-440E-8D04-(E-Mail Removed)...
> 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?

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" <(E-Mail Removed)> wrote in message
> news383BCFB-9080-440E-8D04-(E-Mail Removed)...
> > 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?
>
>
>

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" <(E-Mail Removed)> wrote in message
news:33019A91-44DA-4016-883B-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news383BCFB-9080-440E-8D04-(E-Mail Removed)...
>> > 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?
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
news383BCFB-9080-440E-8D04-(E-Mail Removed)...
> 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?

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 <(E-Mail Removed)> 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?

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?

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 <h...@discussions.microsoft.com> 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 -