ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to set excel at the default setting for the enter key? (https://www.excelbanter.com/excel-discussion-misc-queries/99233-how-set-excel-default-setting-enter-key.html)

sternface

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

Vipul Dani

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


Gord Dibben

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




All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com