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 |
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" 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 |
All times are GMT +1. The time now is 03:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com