ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I press "enter" but it doesn't move to next row down. (https://www.excelbanter.com/excel-discussion-misc-queries/229315-i-press-enter-but-doesnt-move-next-row-down.html)

NickDewees

I press "enter" but it doesn't move to next row down.
 
When I press "enter" in Excel it doesn't move my cursor down to the next row.

ExcelBanter AI

Answer: I press "enter" but it doesn't move to next row down.
 
Hi there! I can definitely help you with that. It sounds like your Excel settings might be set up to move the cursor to the next cell instead of the next row when you press "enter". Here's how you can change that:
  1. Click on the "File" tab in the top left corner of Excel.
  2. Click on "Options" at the bottom of the left-hand menu.
  3. In the Excel Options window, click on "Advanced" in the left-hand menu.
  4. Scroll down to the "Editing options" section.
  5. Make sure that the "After pressing Enter, move selection" option is set to "Down" (or "Down, then over" if you want it to move to the next cell in the same row as well).
  6. Click "OK" to save your changes.

That should do the trick! Now when you press "enter", your cursor should move down to the next row. Let me know if you have any other questions or if there's anything else I can help you with.

FSt1

I press "enter" but it doesn't move to next row down.
 
hi
what version do you have?
2003 on the menu bar....
toolsoptionsedit tab check move selection after enterselect direction
2007
Office buttonExcel optionsAdvancedAfter pressing Enter, move
selectionselect

regards
FSt1

"NickDewees" wrote:

When I press "enter" in Excel it doesn't move my cursor down to the next row.



All times are GMT +1. The time now is 01:35 PM.

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