Hi,
New to using Excel version 2000, have setup a form and after entering data
in the frist row I want to do a hard carriage return in the last data column
to go down to the next row and to the left.
I hope I made that clear.
falcon
Hi,
New to using Excel version 2000, have setup a form and after entering data
in the frist row I want to do a hard carriage return in the last data column
to go down to the next row and to the left.
I hope I made that clear.
falcon
If you select your range first (say A2:E99) and have
Tools|Options|Edit|Move Selection after Enter set to go to the right
it may work nicely for you.
(I like to use the tab key and I can keep my MSAE the way I normally like--off.)
alphadog47 wrote:
>
> Hi,
> New to using Excel version 2000, have setup a form and after entering data
> in the frist row I want to do a hard carriage return in the last data column
> to go down to the next row and to the left.
>
> I hope I made that clear.
>
> falcon
--
Dave Peterson
I usually put a button above my last column and assign a macro that I record
to take me to column A of the next row......actually column B because it
also autonumbers column A for me.........
Vaya con Dios,
Chuck, CABGx3
"alphadog47" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> New to using Excel version 2000, have setup a form and after entering data
> in the frist row I want to do a hard carriage return in the last data
column
> to go down to the next row and to the left.
>
> I hope I made that clear.
>
> falcon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks