Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel 07 - Pressing enter won't bring me to the A column (https://www.askmehelpdesk.com/showthread.php?t=179028)

  • Jan 31, 2008, 03:08 PM
    85Dave
    Excel 07 - Pressing enter won't bring me to the A column
    I'm new to excel and learning it at my local college but am stuck with a small problem.

    say I enter info in A2, then B2... and so on until I get to say... E2.
    If I hit enter after inputting info into E2 my next active cell is random.

    its going between all the letters in the next row down, (in my case.. the 3 row).

    Is there a default to change to get it to go back to the far left column when hitting enter to go to the next line?

    Thanks,
    Dave
  • Feb 1, 2008, 03:05 AM
    JBeaucaire
    I've run into this problem and solved it with WORD.

    I created a 5-cell chart in Word and started entering data. As I press TAB I move from cell to cell and when I enter the data in the 5th cell and press TAB, it adds a new row to the table and jumps me back to the first cell in the new row.

    When I was done, I copied the table, and pasted it into Excel.
  • Feb 1, 2008, 04:04 AM
    85Dave
    Sounds like a fair enough temp. fix but the class must use Excel for the tests and the teacher doesn't know how to fix it in the settings...
  • Feb 1, 2008, 05:09 AM
    JBeaucaire
    OK, here's another way.
    • Go to TOOLS > OPTIONS > EDIT > Move Selection After Enter <RIGHT>
    • Now in your spreadsheet, use your mouse to select the block of cells you will be working in, perhaps A1:E20
    • The selected area turns grey
    • With the cursor in the first cell, start entering data
    • As you press Enter, the cursor moves to the right as instructed above
    • When you get to cell E1 and enter the data, the next cell will be B1

    How's that?
  • Feb 1, 2008, 07:08 AM
    ScottGem
    Another alternative is to create a macro attached to a keystroke. You could record a macro that does a <Down> then <End><Left>. Attach it Ctrl+N so instead of pressing Enter you press Ctrl+N.

  • All times are GMT -7. The time now is 07:49 AM.