Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Active Cell After Pressing The Enter Key

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hello, everyone. I started learning Excel 2003 a week ago and I have a basic quesion. I will be very thankful for your reply.

Whenever I press the Enter Key after entering data in a cell, the cell below is selected. I want Excel selected the cell right to the cell that I just entered data after I pressed the Enter. How should I set it in Excel 2003?

Thank you for your reply.

RealNewbie


Similar Excel Video Tutorials

Helpful Excel Macros

Enter Text/Characters with a Double-Click of the Mouse
- This macro allows you to enter any text or number, that you specify, in a cell on which you double-click. In the exampl
Add an Input Message to a Cell - Message Appears When the Cell is Selected in Excel - Data Validation Macro
- Add data validation input messages to cells in Excel with this free Excel macro. These messages appear when a specific
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
- This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can filt
Print Selected Worksheets in Excel
- This free excel macro will print all selected worksheets in Excel. If there are no other worksheets selected the active
Basic Web Query in Excel - Import Data from the Web into Excel
- Import data from the web into Excel with this macro. This is a basic web query macro that will import data from any web

Similar Topics







I've created a calculator (Excel 2003) in which there are only four cells (D8:D11) unlocked for users to enter data. Once 'Enter' is pressed in D11 the calculation is made.

Hidden in a remote part of the sheet are four more unlocked cells that allow the calculator to be customised by entering personal information.

When I press 'Enter' in D11, one of the remote unlocked cells becomes the active cell. Is there a way to force D8 to become the active cell when 'Enter' is pressed in D11?

Thanks.


I played an online simulation game a few months back that was driven by Excel. In the simulation game interface were screens and on these screens, the players of the game could enter values into boxes on the screen. When the user pressed Enter, it would update the simulation game with your choice and if you wanted, could immediately type in a different value and press enter.

My point is, like in a normal Excel spreadsheet, when you press enter, it goes to the next cell below. In this game, the (whatever it's called... active cell?) would stay in one cell when Enter was pressed.

Is this a text field? I've looked all over on how to put a text field in a specific cell. I've went to Developer tab and on the Insert the Text Field (Form Control) is unable to be selected so I guess my question is, how do I add a Text field to a cell if it's possible?

Very similar to a Search box. When I enter alphanumeric characters in the text field (cell) and press enter, it activates a button which runs my macro.

Thanks for any help I can get with this. I've attached an example.




I would like a macro to run every time I press the enter key anywhere on a specific sheet. I will be entering data in several cell before pressing enter, so the macro only needs to run once enter is press and not when the cells are changed.

Probably another simpler solution.....

How do I offset to a cell when I press enter?
When the sheet is activated, cell B2 is selected.
When a value is entered into B2, which satisfies 'data validation' and enter is pressed, I want to move to cell B8

I am sure I knew how to do this, but going round in circles searching old threads.

Ta in advance


I have created a spreadsheet requiring data to be entered in a set
order. By that I mean the first entry will be in the first blank cell in
column "B".
On pressing "Enter" I want the focus to move to C, D, E, F then M, N and O.
Two questions:
How do I get Excel to open with the focus in the first blank cell in
column B?
How do I set the movement of the focus on pressing "Enter"?
The cells between column F and M are calculated cells and do not need to
be selected. The cell in column A has the date automatically calculated
when data is added to cell B, C or D.
Please make your reply simple for me to follow as I am rather ignorant
as far as VB is concerned.

Orf



Hi everyone,
Weird problem with excel 2003.
I try to edit a cell and put a different number in. Then I press the enter button. For some reason, for this particular file only, pressing the enter key will result in cancelation of the UNDO option and I cannot go back and undo the change I made.
Does it make sense?? I have some circular reference in the workbook. And it shows "calculating" after I am pressing enter. But there is nothing in that cell the requires calclulation...just a value (number) I am putting in.
Weird thing is that the enter key works just fine in excel 2007 and does not cancel the undo option. I need it though working in 2003 as well.

Does anyone have any idea what is going on?
Can it be that the enter key is code programmed in some sort of way?
Is there a way to bring back to default?

Thanks so much for helping me out!! This problem is driving me crazy!


I have a Print marco on one sheet that when pressed will print out the other sheet

Sub s53print()
'
' s53print Macro
' Macro recorded 22/02/2003 by Ross
'

'
Sheets("S53worksheet").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("S53input").Select
End Sub

when i hide the sheet that i need to print and i click the print button i get a error with the macro does anyone know how i can correct this problem

Also is there a way of entering data into cells pressing return and going to the next cell, but when you reach the last of the input cells and you press return you go back to the first cell and enter new date

e.g

cell 1
cell 2
cell 3
cell 15
cell 16

enter date in these cells when i get to 16 and press the enter button I return to cell 1 to enter different data

p.s
I know you can hold down ctrl and select cells but this is not what i need to do thanks for that any way ( i have post this question before).

Thanks


How do I get Excell 2007 to replace a numeric value with text upon completion of entering the value into a cell?

For instance, I have twelve employees that I know by number. I want to enter the value of say 1 and have Excel 2007 replace that value with the employee's name (Grindstaff) when I hit enter and do the same for all 12 employees. So, when I enter 5 into a cell and press enter I want it to replace 5 with Smithson. When I enter 9 and enter I want 9 to be replaced by Richardson, etc.


Hope someone can help. I have twenty-three columns of data. I enter data into one cell and tab across entering data in all cells in that row. At the last cell I would hit enter and the first cell in the row below would become active. That suddenly stopped happening and now when I hit enter the active cell would move straight down. This makes me arrow to the left back across the row to the first cell. I understand that I could just hit the HOME key but my columns do not start at column A. i.e. Enter data in A4, Tab to B4, Tab to C4 then Enter. A5 should now be active but it is C5 instead. This has become a real pain. Thanks in advance.


I'm not quite sure how this problem arose, but it is quite annoying. In Excel 2007, pressing ENTER has become the equivalent of pasting. This means that if something has the dashed lines around it, because it was cut or copied, if I press ENTER it gets pasted into the selected cell.

This is annoying because I usually move around using the ENTER key which is set to move down a cell when pressed.

I couldn't find any reference to this problem, and changing hotkeys only gave macro keybinding, which I already know.

Any thoughts? Thanks


Dear All,

I need a macro that will do the following action:

When I enter a data on Cell A3 the active cursor should jump to B1.

E.g. I will be entering data in A1 and press Tab then in A2 and press Tab then in A3 and press Tab. Once I have done in A3 and press Tab the active cursor should jump to B1. Again I will enter in B1 then in B2 then in B3 and pres Tab.

Please note that I will not press the Enter key anywhere. I will use only the Tab key to go from A1 to A2 and then to A3.

Please help.

Regards,
Bency


When you hit the enter button, it should jump to the cell below the one you currently have selected. Well, mine doesn't do that anymore? My tab works fine to go to the cell to the left, but enter just keeps the current cell selected. I know it isn't the Keyboard, b/c it works for every other app. What have I disabled/enabled to cause this? This happens with both the "return" enter button and the enter on the number pad. As of right now, either a mouse click or the down arrow is the only way for me to jump to the next cell. All help is greatly appreciated.

Thanks,

Reese


I have posted this as a new user but hought I may get a better reponse here.I am using ms excel to enter data, 1 for Yes and 2 for No, for 300 items/questions listed successively in column A. The data is then tallied on another excel page. However, I would like to have the entry of 1 or 2 provide the jump to the next cell down ( each time1 or 2 is entered) rather than have to always press enter key to go to the next cell. Any ideas how to proceed?


Usually when you have entered text or a number in a cell, you press enter and are moved one row down. This is fine when you are inserting data column by column, however right now I am entering some data row by row, and am finding it rather tedious pressing enter and two arrow keys to get to the next cell.

Anyone know if I can move directly to the right?


Hi.
First of all, thanks again for this fantastic Forum. I would like to know if this is possible to do.
Cell A1 is currently empty and without any formulas in it. I am going to enter data in B1. Lets say 100. As soon as I press enter this value must show in cell A1. Here is the trick. As soon as this value is entered in A1, I want B1 to go blank again. Now I enter 200 in B1 and after entering A1 must show 300, (100+200) and B1 must go blank again.

The reason for this is I have to update the worksheet every day with a lot of data and at the moment I had to add the data on the sheet to the data I want to update with using a calculator and then enter it back in A1. If there is a formula for this I can update A1 everytime by just putting the new value I want to add in B1 and press enter.

Thanks for your time.

Lukas.


I recently switched to Excel 2003. I create a large number of hyperlinks in Excel and activate the links quite often. In the old version of Excel I had, I could highlight the cell and press the enter key to activate the link, but in 2003 can only activate the links using the mouse. The continual clicking has quickly grown tiresome.

Is there a setting that can be adjusted in Excel 2003 that allows for activation of hyperlinks with the enter (or return) key?


In excel when you press enter it moves to the cell below. It there a formula or a way to change which direction it shifts to? I would like to enter. I would like to enter data in cell 1 then 2 then back to 3 then 4 then back to 5 then 6 and so on. Without using the arrows or keys on the keyboard.

Thanks





Hi there,

I exported a report from MYOB into Excel. When using any function e,g "istext", it shows True even if a cell is blank. I have checked that automatic calculation is working, general format is selected. Even I copied a cell from another sheet and did a paste special but it did not work. Although when I selected a cell, pressed F2 edit mode and then enter, it updated the formula. However if I select all cells and press F2 and then enter all the cells either become blank or have one text (depending what the active cell is).
Can anyone please advise on how to update formulas of all cells at once. I have tried F9, shift+F9, Shift+Alt+F9. Nothing works. Or is there a better way to approach this. Even I have tried Clear Cell-Format. Nothing works.

Thank you for your time.

Regards,

Zarak.


I have a sheet which has only 3 input cells, but only one input cell is
required for a user in a given state. I've disabled the "move selection after
enter" function in tools/option/edit and when they enter a value and press
enter the active cell stays the same - which is what I want.

When I protect the sheet, the active cell jumps to the next unprotected
cell. How can I stop it doing that?




I have a master spreadsheet that I enter data into and save as the date each day. I have formulas in one column that reference cells in the neighboring row, except for one cell in the column that I have purposely left blank (It does not have a formula referencing the neighboring row). When entering data into the referenced cells excel automatically enters a formula into this cell. It will only doe this if I enter data in the cell above the referenced cell and the referenced cell. How can I get excel to stop doing this. It was never a problem when I was using excel 2003, I am now using 2007. Thanks in advance for any help.

P.S.
If the above is unclear here is a simplified version of what is happening: enter =A1 into cell B1 and copy down to B5. Delete the formula in B3. Now enter numbers into A1 through A5 and you will notice excel will auto enter the formula into cell B3.
(Correction: copy to B10 and delete from B5, enter into A1:A10).


In Excel 2003 after inserting a hyperlink to open a picture file stored in
the local drive the user needs to be able to open the file by pressing Enter
on the cell that contains the hyperlink rather than by clicking on it with
the mouse. This feature is enable in Excel 2000 but it the not work in 2003.
(the file type or location does not matter). In short, how can a hyperlink be
opened by pressing Enter in Excel 2003.
Thank you in advance for your help,
Carolina



Hi All:

I seek the knowledge of the experts once again...

Can you tell me if it is possible to have the active cell change after a certain number of characters are entered?

I have a spreadhseet that people enter a 36 digit code into. The different fields have a different amount of characters in them. The string is as follows:

J17 can enter 3 characters
K17 can enter 6 characters
L17 can enter 4 characters
M17 can enter 6 characters
N17 can enter 6 characters
O17 can enter 4 characters
P17 can enter 4 characters
Q17 can enter 4 characters

SO what I would like to happen is the user enters the 3 digits in J17 and then the active cell becomes K17 where they enter 6 digits and then the active cell becomes L17... Does this make sense? Currently the user has to Tab to the next cell but if they could enter the number contu=inous that would be great.

Any ideas?

THANKS,
Mark


Hello

Not sure if anyone can help but I am intrigued to know how the following is done.

On a spreadsheet (excel 2003) which has no macros / vb code that I have acquired, there is a cell that if I were to enter any data and then press enter then a tailored message box appears (yes, no, cancel option). If I were to copy this cell and enter it into a different spreadsheet of my choosing, then enter data and press enter again, the exact same message box appears.

Does anyone know how this is done, I honestly thought code was required for such a thing but seems not!

Many Thanks for your help


I was just upgraded from Excel 2000 to Excel 2003 and discovered that my Hyperlinks can no longer be activated by pressing the enter key when the hyperlink cell is selected. It appears I must use the mouse to click the cell in order to activate the hyperlink. Can this problem be fixed?


Hi there,

Various users enter data into a spreadsheet. Every time they enter say a quote, they will enter it into a new row. What I would like to happen is that every time they get to Column F (F9:F10000) a userform pops up. The userform will have checkboxs in it. There will be 6 checkboxes. What I would like to happen is when some of the Checkboxes are ticked/selected then a piece of text is entered into the cell that was selected. I would like the option also that you have to click OK to confirm this or Cancel to close the Userform.

An example is:

Checkbox 1 = Lee
Checkbox 2 = Tracy
Checkbox 3 = Sam
Checkbox 4 = Kevin
Checkbox 5 = Jackie
Checkbox 6 = Steve

If say Check box 1, 3, 5 were selected and I press OK, then the cell would show Lee, Sam, Jackie.

I would also like it if once selected if you clicked that cell again then the Userform would pop up retaining what you have already selected.

Is this possible?