Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hard return
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find replace text or symbol with carriage return | New Users to Excel | |||
RETURN intersecting value with known horizotal & vertical?? | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Return the smallest value | Excel Worksheet Functions | |||
VBA: Return Searched Value Inputed by End-User | Excel Worksheet Functions |