Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return to next row in first column when entering data in Excel
I am creating a list that that uses more columns than can be covered on the
screen. The problem is when the data is entered in the cell in the last column, I need to return to the next row in the first column. Yet this cell and row is not visible to click onto. Is there a command like in Acess that will take me to the end of my list, ready to start another row of data. if not, are there any suggestions to accomplish this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return to next row in first column when entering data in Excel
Try this. When you enter data in a cell use TAB to go to the next cell and
when you get to the last cell in that row, enter your data and then hit ENTER. Returns to the next row in the first column. HTH Regards, Howard "DaddyRay" wrote in message ... I am creating a list that that uses more columns than can be covered on the screen. The problem is when the data is entered in the cell in the last column, I need to return to the next row in the first column. Yet this cell and row is not visible to click onto. Is there a command like in Acess that will take me to the end of my list, ready to start another row of data. if not, are there any suggestions to accomplish this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return to next row in first column when entering data in Excel
One small point here Howard that can be useful in some cases.
Returns to the next row in the first column. Should read............. Returns to the next row in the column from which you started. Might be a user wants to start Tabbing across from Column D for example. Gord Dibben MS Excel MVP On Mon, 25 Jan 2010 15:15:10 -0800, "L. Howard Kittle" wrote: Try this. When you enter data in a cell use TAB to go to the next cell and when you get to the last cell in that row, enter your data and then hit ENTER. HTH Regards, Howard "DaddyRay" wrote in message ... I am creating a list that that uses more columns than can be covered on the screen. The problem is when the data is entered in the cell in the last column, I need to return to the next row in the first column. Yet this cell and row is not visible to click onto. Is there a command like in Acess that will take me to the end of my list, ready to start another row of data. if not, are there any suggestions to accomplish this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return to next row in first column when entering data in Excel
Of course you are correct on that point, I knew that and should have noted
it is the column you start in to which it will return. And I bet the OP will do as I do once in a while where I hit accidentally hit Enter instead of Tab and get the 'carriage return' effect but still have info that needs to be put into that row. So I click back to the next cell in the row and use Tab to finish entering data... and then hit Enter... woops only goes back to that errant next row of the column where I hit Enter mid way through. You do your 'expletive deletes' and start over at the proper first column. Thanks for the clarification. Regard, Howard "DaddyRay" wrote in message ... I am creating a list that that uses more columns than can be covered on the screen. The problem is when the data is entered in the cell in the last column, I need to return to the next row in the first column. Yet this cell and row is not visible to click onto. Is there a command like in Acess that will take me to the end of my list, ready to start another row of data. if not, are there any suggestions to accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfering data in another column entering more sorted data | Excel Worksheet Functions | |||
Seeking the character code for entering a Hard Return in a cell? | Excel Discussion (Misc queries) | |||
Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
how to move the cursor to column A after entering data column F | New Users to Excel | |||
How do you Stop Entering Duplicate Data in a Column? | Excel Worksheet Functions |