ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Get excel to automatically go to the next cell w/o pressing enter (https://www.excelbanter.com/excel-discussion-misc-queries/236771-get-excel-automatically-go-next-cell-w-o-pressing-enter.html)

amr

Get excel to automatically go to the next cell w/o pressing enter
 
After I enter something in a cell I would like the selected cell to move to
the next cell without having to press enter. Is this possible? If so, how do
I do it?

Mike Rogers[_2_]

Get excel to automatically go to the next cell w/o pressing enter
 
AMR

What are the conditions that excel will know you are done entering data?
Would it be after a space, or period, or some other end of a sentence
punctuation, but if you are entering numbers will it always be the same
number that is last, or will it be the same number of numbers? How will
excel know you are done?

Mike Rogers


"AMR" wrote:

After I enter something in a cell I would like the selected cell to move to
the next cell without having to press enter. Is this possible? If so, how do
I do it?


Steve Yandl[_3_]

Get excel to automatically go to the next cell w/o pressing enter
 
If you plan to always enter the same number of characters in a cell, it
could be done. Otherwise, you will have problems. For example, what if you
want to type 25 in a cell? You type the "2" and the subroutine moves you to
the next cell because you've entered something and you're never allowed to
enter the "5" to complete "25". The Enter key is how you tell the
application you're through typing in the data for that cell. Explain the
type data you're entering and someone might have some options for you.

Steve



"AMR" wrote in message
...
After I enter something in a cell I would like the selected cell to move
to
the next cell without having to press enter. Is this possible? If so, how
do
I do it?




All times are GMT +1. The time now is 09:00 PM.

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