Close Window   
Free Ebook
Got an Excel Question?
Ask it in our Excel forum!
TeachExcel.com
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



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

View Answers     

Similar Excel Tutorials

Quickly Enter the System Date in Excel - Keyboard Shortcut
You can insert the system Date by holding the Control (Ctrl) key and pressing the colon or semicolon key. (Ctrl+;) ...
Get the Name of a Worksheet in Macros VBA in Excel
How to get the name of a worksheet in Excel using VBA and Macros and also how to store that name in a variable for ...
Select Cells in Excel using Macros and VBA
This is actually a very easy thing to do and only requires a couple lines of code. Below I will show you how to sel ...
Close Excel Workbook using VBA Macros
How to close an Excel workbook using VBA and macros, including how to save the file before you close it or discard ...

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.

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!


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


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?


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).


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 have a spreadsheet where the user is supposed to enter text into a specific cell. That text may be a single sentence, or it may be several paragraphs. I want Excel to convert the enter key to a carriage return and cause the cursor to stay in the same cell.

I have something kind of working like I want, but there are still some issues:


Please Login or Register  to view this content.


This will add the enter like I want, but exiting out of it is cumbersome; you have to press enter one last time, then escape to jump out of the worksheet_change sub (if you just press escape, you loose the last line).

I'd like to have the Tab key jump out, or have the escape key work without having to press the proceeding enter.

Anyone got a better method?

I am using a normal vlookup on data that is coming from a database (Business Warehouse - SAP... FYI).

When I run a vlookup from an excel spreadsheet to that data dump some of the values come up #N/A even though there is a match.

I know it is because of a format issue but am not sure how to fix it. The only way that works is by going to the data dump excel sheet and pressing F2 to get into the cell and then hitting enter to somehow change the format...

so when there are like 100 lines I am just pressing "F2, Enter, F2, Enter, F2, Enter, F2, Enter, F2, Enter, F2, Enter, F2, Enter,.. etc." the WHOLE way down and right after I exit the cell the Vlookup returns the correct value.

Thank you in advance to anyone who can be of help.


Dear all,

I got two problems in using the excel,

First is when I type in a number like 1350, excel will change
it to 13.5
ehat happened and any setting that I need to make it back to normal.

Second is that when I finish entering data in cell and Press
Enter button, it should go down to another cell, but now when I press
Enter, it just stay in the same cell and do not move to any cell.

Please help. Thanks.



I'm quite new to VBA, but I'm developing a spreadsheet with a macro. On a worksheet, I have one cell used for entry of a text string. It's a merged cell. The macro returns a result based off of what is entered into that merged cell. The easiest and most common method of entering data into that cell is copying the string onto the clipboard from an outside app. and pasting it into the merged cell. However, upon doing so, the user always gets the message, "Data on the Clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?" Upon clicking the OK button, the user gets another message, "Cannot change part of a merged cell," and the data is not entered. (First of all is there a way to address this?)
To work around this, I figured I'd just use an activeX textbox control inserted onto the worksheet (a userform is too much for the purposes of this macro and the users who will use it). I can size the textbox to the length it needs to be, and theres not "merged-ness" to overcome. However, when the user strikes the enter key, nothing happens. The cursor just stays there. Isn't the enter key supposed to "enter" the data? (Second, is there a way to fix this?)
I'm guessing i'll have to program some code in the keypress event for the enter key. Well, what do I tell it to do? Losefocus? just execute the macro? copy the textstring to the cells beneath the textbox? Move focus to the worksheet? I'm not sure what to tell excel to do when the enter key is pressed.

Thank you for your help!


Dear All,

I am trying to put a formula into a cell using VBA but am having trouble with the range of cells. I am using Excel 2003.

I have a column of amounts with some blanks mixed in. I know my first cell in the range is always row 2 of the column of the current active cell. I know the last cell in the range is always cell directly above the current active cell. How do I pass this range to get VBA to enter a formula?

For example, column C has amounts. Cell C1 has a label. Cell C2 is the beginning of my range, which may or may not have an amount. The active cell is C100. In the active cell, I want to use VBA to enter the formula =SUM(C2:C99) If the active cell is C345, I want the formula to be =SUM(C2:C344)

I tried to use ActiveCell.FormualR1C1 = "=SUM(R[]C[]:R[]C[])" However, I can not figure out how to enter/show the beginning cell of the range, which is always the current column row 2. The ending cell reference would be R[-1]C[0]

Please help make this Holiday Season joyfull.

Thanks,

General Ledger


I have protected a sheet so that only unlocked cells can be selected. This results in the cursor moving one row down every time I press Enter, just as if Tools -> Options -> Edit -> Move selection after Enter had been cheked and direction Down selected, however, this not so.

If I allow locked cells to be selected the cursor stays where it is.

How can I make the cursor stay after pressing Enter and still block selection of locked cells?

NSV


I need a private sub for a workbook that will switch back to the entry cell after the selection is made and calculate. Meaning Cell A2 is the cell where data is entered and after pressing enter or tab or clicking out of cell A2, cell A2 should be reselected and a calculate command should be issued. How can this be done?


In Excel 2003 when I click on a cell it selects the cell just like it should.
However, when you move the mouse after doing this it continues to select
every cell between the one you selected and the Pointer Arrow. It is acting
very much like the Ctrl Key is stuck in a pressed condition. I have switched
out the keyboard and the mouse as well as uninstalled and reinstalled Office
2003. None of this fixed the problem. Does anyone have any ideas as to what
it may be?





Hello

I have a spreadsheet I am amending. What happens sometimes is I enter a formula into an empty cell, say for example in cell A1, I enter =if(C3="","",C3), and press enter or click another cell, and the formula is entered fine, ie Cell A1 displays what ever value is in cell C3. Then I might decide to amend something like may be just change the formula to =if(C3="","",C3+1), and press enter or click another cell, the formula just remains visible in cell A1 (ie not entered). I might go back and try and type in the original formula, and this will just still remain visible in cell A1. Basically, formula typed into a blank cell does not get 'entered' sometimes and just remians displayed in the cell. I have checked the formatting of the cells and played aroung with 'General', 'Text', 'Number' etc but without any success. Any ideas what might be causing this please. Many thanks


Is there a way making A1 always equal the contents of the last cells entry.

I found this whilst looking....

http://www.mrexcel.com/forum/showthread.php?t=22149

but it puts the active cells contents in A1.

In my case the active cell is empty and when I press enter the active cell has changed to the next cell down....Hmmmm...

So basically what Im trying to do is:

Enter xyz in cell d1 and when I press enter xyz appears in D1 and A1
When I then enter ABC in D2 and press enter again ABC appears in D2 and A1. whilst D1 still contains xyz.

Does that make sense???

Why am I doing this? because I need to validate the contents of a complex cell entry and the standard Validation doesnt work for what I need to do.

see: http://www.mrexcel.com/forum/showthread.php?t=416482


Martin