Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

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.


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 ...
Print All Worksheets at Once in Excel
How to print all worksheets at once from Excel. This saves you the time of having to go to each sheet individually ...
Easily Enter Fractions into Excel
This is a very simple trick to enter fractions quickly without having to manually format anything. This allows you ...

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 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 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?


OK I have calmed down :D.

I have Excel 2003. I am working on a spreadsheet that many users (that do not understand Excel nor how to utilize the built in formatting) have had their hands in.

I have fixed previous text formatting problems in each cell by deleting all the spaces users had put in to make the next line of words line up just below the previous one in the same cell. They did not know how to use the SHIFT + ENTER to create a hard return in the cell - wrap text is used but it does not always wrap at the right word thus we need to use the hard returns.

While fixing these cells some of them do not accept the SHIFT + ENTER. It just thinks I pressed the enter key alone. (My keyboard is fine)

Is it possible to have a table in this spreadsheet somewhere and maybe this does not allow me to use SHIFT + ENTER?

Thanks SO MUCH in advance for any help!

I'm running Windows XP with Office 2003 installed. Recently, without any settings changes that I'm aware of, when I open an Excel document, I can click into a cell and after that I can't do anything. When I move the mouse, it acts like I still have the left mouse button pressed and it selects cells as I move my mouse. I have checked to make sure the Shift, ALT and CTRL keys are not stuck. I tried pressing ESC, but that didn't release it. I tried using the arrows to move the selected cell, and it wouldn't allow me do change the active cell. It won't even allow me to type in the active cell or close the window. I have to go into another program then right click on Excel and close it from the task bar.

Has anyone else run into this problem and, if so, how did you resolve the issue?

Is there any way to re-map keyboard keys (for my example would be the {Enter} key), but only when a particular macro is run?

I'm automating a data entry screen where the user is used to hitting the {ENTER} key, but in their original program(not Excel) it responds as if you hit the {TAB} key.

In other words, normally when the {ENTER} key is pressed, the cursor moves to the next cell below. I would like it to move to the next cell to the right.

I don't want to re-map the keyboard permanently outside of Excel, again only when this particular routine is run.

I have Excel setup so that when I press "Enter" I move to the next column.

However, I would like to set up my spreadsheet so that when I hit "enter" in the last column of data, it moves to the next row down.


I have data I need to enter in Row 1, columns A-L.

I enter data in A1 and hit "enter" and I move to cell B1 and so forth, always moving right. When I get to cell L1 however and input my data and hit "enter" I would like to be moved to cell A2.

Is this possible?

I have a spread sheet and when I enter informaiton for some reason it turns the cell red. I am fairly new with excel and can not figure out why. I never set it up to change color and have looked everywhere the cell is set up to only allow 50 characters to be enter but even if you enter less than 50 it turns red. I thought maybe its how the info I am entering is entered, for example LSF-halloweensouthflorida/halloween091/bullethole. I clicked on format cell and tried different option but it still turns red when you hit enter. I went to fill option but their is no fill. Does anyone have any suggestions?


I am entering lots of family history data into a spreadsheet. At the simplest I have columns (in cells A1 B1 C1) the headings, Surname, Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next row down). What I want to happen is when I have entered the last data in a row and pressed <Enter> I move automatically to the A-column in the next row down.

Is this possible?

Regards and a Merry Christmas to all


Could anyone please help me.
I want to enter a number 0 to 999 in cell A1 and when the enter key is pressed move the contents of cell A1 to A2 and A2 to A3, cascading down until A40. So after five numbers the first number I entered woul now have cascaded down to cell A5 ready to go into cell A6.
Would I have to use some kind of program or does excel have a command for this?

Thank you in advance.

I have a few files with lots of simple formulas (30,000 +). Lately, I have seen some inaccurate numbers being produced by these files and after troubleshooting it turns out that some of these formulas did not / and will not calculate.

This is not a simple turn on autocalc or press F9 problem. Believe me, I have tried it. The only way I can get the cell that will not calculate to respond is be entering edit mode (F2) and pressing enter.

Has anyone experienced this?

Hi everyone,

I have the code below that runs Macro1 when I select cell within the range $B$7:$I$1000.

But I want to run Macro1 If I enter a value in selected cell, not only when is selected, because Macro1
is intended to copy the value I enter to other cell.

How can I do this?


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 'target range to monitor 
If Not Intersect(Target, Range("$B$7:$I$1000")) Is Nothing Then

  On Error Resume Next

Application.EnableEvents = False

    Addr = Target.Address
    If IsEmpty(Range(Addr)) Then  'Verify if current cell selected is empty
       'Do some code 

         Call  Macro1  'I want to run this macro if data is entered in Target cell 
    End If
  On Error GoTo 0

Application.EnableEvents = True

End If

End Sub

Many thanks in advance.

Best regards

I'm working with an invoice document that someone created on Excel 2003.
It's a great document, but we want to program either the TAB key or the ENTER
key to move to a different cell within the worksheet. Example: After typing
the Date, enter automatically to Invoice Number, then enter automatically to
Company Name, and so on. Is there a way to start at cell N1 ,then program
the Enter key to automatically go to cell N7 after that, then C9 after that
and so on.

Any information is GREATLY appreciated!

This is my first post on here so sorry if this is posted in the wrong section but I figure you can never go wrong in general right? The question I have is I have an excel sheet that I want to use to enter survey results. We are using 1 - 5 for a scale as unsatisifed to extremely satisifed, some questions use 1 for yes 2 for no and 5 for no reply, and some use 1 for yes (there are four answers and the user can only select one). The question I have is there will only ever be one character entered into a cell is there anyway to tell that there has been a character entered and automatically move to the next cell (downward)?

I'm going to be using Excel to take notes, so I'm attempting to make it easy to add bullet points.

I have code that adds a bullet point if the cell's blank, and creates a new line and adds a bullet point if there's already a value.

Right now though, I'm having to hit Enter (which takes me down a cell), press shortcut to run macro, then press up to go back to the cell and hit F2 to go into the cell.

So, I have a few questions:
1. Is it possible to run a macro while within a cell? (Typing in a cell prior to hitting enter)
2. Is there a shortcut that accepts the value (like Enter) but doesn't move to a different cell?
3. Is there a way in VBA to do the equivalent of the F2 shortcut?

I have:

Dim iRow As String 
iRow = ActiveCell.Row 

If you like these VB formatting tags please consider sponsoring me in support of injured Royal Marines

However I need to make iRow be the cell that was last active.

So if i enter data in A10. Then select a different cell, say G7.

I want iRow to equal that of the row 10. But this has to be after another cell has been selected so the value of A10 is in the cell.

Is there a way to say PreviousActiveCell.Row???


I want to enter data in a cell in the form of paise and get it converted to rupee i.e divide by 100, as soon as I press enter key.E.g:26.94 should show 0.2694.In custom formatting I can multiply by entering * 100 in Type area but cannot divide.How do achieve this ?

Hi guys.

I am trying to create a simple Macro in Outlook (2002) which will send a reply back to the original email recipient with specific text in the subject and body. (I know I could probably do this using Rules but I need to be able to manually choose who to send this reply to.)

I found some VBA and tailored it to suit but when I click on the menu button that I linked to this Macro, I get a prompt saying, "A program is trying to automatically send e-mail on your behalf..." and you need to click YES to send it. If you click NO, you get a debug error.

Is there something in the code (copied below) that I can add/amend to stop this prompt from appearing? (I thought this message only appeared if you use VBA from another program, not when entering VBA directly into Outlook.)

Also, when I click on the Macro button, it opens up the auto-reply in a new window so that I'm still left with the original email open. Is there a line of code I can enter that will close this email too? I would appreciate your help.

Sub EmailReply()
Dim Reply As Outlook.MailItem
Dim Original As Outlook.MailItem
Set Original = Application.ActiveExplorer.Selection(1)
Set Reply = Original.Reply
Reply.Attachments.Add Original
Reply.Subject = "Important Notice"
Reply.Body = "Body text to be entered here"
End Sub



I am a new poster, but have been reading this forum for a while now. Friend from work pointed me to it. My level of excel is limited to basic functions, finally figured out vlookup, and simple macros.

My query is this? I have a workbook and within it a worksheet with names, addresses, vendor codes, dates etc. Conditional formatting is used to highlight when some one data expires. Primarily that is what this workbook is used to track, expirations.

However, we have added two new columns for a different department and have protected the workbook on the server. What we would like to see happen, department 'A' can edit all of the workbook while user in department 'B' can only edit a range (say d2:e1000) on the worksheet titled 'Master'.

I am using Excel 2003 and have gone into the toolbar and selected Tools - protection - allow users to edit ranges ... and have selected New - named my range - selected my range - and entered password (*). I have selected the user based from thier network ID and saved the document. I then protected the worksheet. I thought I was good. I was wrong.

The user in department 'B' is still able to open the workbook and select any cell and edit. They should only be able to edit those two columns. What did I miss? Is there a better way to do this? Is it possible when openning excel a box appear and the persons that are admins enter a password granting them all access while another user could enter user for the login ID and a different password and be granted the limited access I described above? Whats the best solution?

I have some code that runs when the user double clicks. Upon that double click, a list box is displayed with three columns. I want the user to select a row and press OK. Upon pressing OK, I want the value from Column 1 to be populated into the target cell that was originally double clicked on.

I have everything working except for the getting the value selected and then placing into target.

I've used code like this before to figure out what the user selected:

For n = 0 To (CountListArray - 1)
If ExpenseErrorsListBox.Selected(n) = True Then
ItemSelected = ExpenseErrorsListBox.List(n, 1)
End If
Next n

How would I then, but that value into a cell?

I need some guidance.

I have a textbox in my userform where anything typed in the box is entered into cell A2 in my worksheet. However, multiple lines of text are not properly displayed in my worksheet. I have enabled MultiLine and EnterKeyBehaviour in the properties window of the textbox so I can type multiple lines in my textbox. The problem is that when I press the button to enter the text from my txtbox to cell A2, the cell doesn't actually display the text in separate lines. It just places a square symbol in the place that enter should have been pressed and the text should have been split into separate lines.

How can I get the separate lines of text in my textbox to be properly displayed in a cell? Thanks for your help in advance..


I work in a computer lab, and a student is having a rather bizarre problem.

Whenever she clicks on a cell, the cell to the right of it is also selected. When she tries using tab to move to a new cell, she can only move between the two selected cells. Same with using the enter key. As such, it is extremely difficult for her to modify only one cell, since she always has two selected.

I looked around on the internet, and found a few suggestions. Namely, the F8 key, as well as Ctrl+F8. However, pressing the F8 key only adds more cells to the autoselection, and Ctrl+F8 allows her to select one cell, but also highlights the cells around it, and when we tried to select other cells, every cell we clicked stayed highlighted.

Additionally, sometimes when she clicks a cell, it will just select that one cell. Click it again, and the problem is back. I haven't been able to determine any patterns to this behavior, and I know there is no problem with the input (the keyboard and mouse are standard-issue in our lab, and we keep them well maintained). She doesn't remember the exact moment the problem began, so I don't know what to undo.

Any help would be appreciated.

It seems fairly easy, but I can't figure it out. Is it possible to set up a macro to enter today's date into the currently selected cell when ran?


I'm trying to figure out a way to be able to enter different data into a particular cell on one sheet and have this data be listed as individual items or rows on a different sheet.

For example, let's say I have cell A1 on Sheet 1 as my cell that will have different text entered into it. Let's say I type the word 'dog' into A1. I would want this copied into Sheet 2 in cell A1 as 'dog'. Now, let's say I want to enter the word 'cat' into A1 on Sheet 1. I would then want this new text to not replace A1 on Sheet 2, BUT to drop down another row and be in cell A2 on Sheet 2. Does that make sense??? In other words, Sheet 1 would be for data entry and would show the last text entered into cell A1. Sheet 2 would create a log or history of the text that was entered into A1 of Sheet 1.

Any thoughts on how do do this?


I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar. I am extremely confused, can anyone help?