Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to set excel at the default setting for the enter key?
I have a large database to complete and am wondering if there is someway to
make it easier to continue typying and not have to stop to go to the begining of each new row? Ex: Typying across colums A-G, the next row I have to stop typying and make sure it is in column A, is there a way to set this up that I can continue typying and tab away? Some said try the enter key --- that didn't work. Someone else said set excel at the default setting for the enter key. But I don't know how to get to the default settings if this even works. Can someone help? Please Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to set excel at the default setting for the enter key?
You can select the range and strat typing after G it will come back to A
-- Vipul C Dani Assistant Training Manager Prgati Software Pvt Ltd. "sternface" wrote: I have a large database to complete and am wondering if there is someway to make it easier to continue typying and not have to stop to go to the begining of each new row? Ex: Typying across colums A-G, the next row I have to stop typying and make sure it is in column A, is there a way to set this up that I can continue typying and tab away? Some said try the enter key --- that didn't work. Someone else said set excel at the default setting for the enter key. But I don't know how to get to the default settings if this even works. Can someone help? Please Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to set excel at the default setting for the enter key?
Start in column A and Tab your way to Column G.
When leaving Column G hit the ENTER key to go back to A and one row down. Make sure your ENTER key is set to move down via ToolsOptionsEdit "Move selection after enter" Gord Dibben MS Excel MVP On Thu, 13 Jul 2006 21:38:56 -0700, sternface wrote: I have a large database to complete and am wondering if there is someway to make it easier to continue typying and not have to stop to go to the begining of each new row? Ex: Typying across colums A-G, the next row I have to stop typying and make sure it is in column A, is there a way to set this up that I can continue typying and tab away? Some said try the enter key --- that didn't work. Someone else said set excel at the default setting for the enter key. But I don't know how to get to the default settings if this even works. Can someone help? Please Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting default values in a drop down list in excel? | Excel Discussion (Misc queries) | |||
Setting default font and colour | Excel Discussion (Misc queries) | |||
Excel Virus - Corrupts Default Options (Excel 2000) | Excel Discussion (Misc queries) | |||
How do I change the default number format in excel? | Excel Worksheet Functions | |||
Enter Data Into Another Excel File Automatically | Excel Worksheet Functions |