How to go to next row first column

[suesailor]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel When entering data In the 2004 version, when I hit Return, the cursor would go to the next row and the 1st column of the spreadsheet. Now I can't seem to make it do that in the 2008 edition. In Preferences I have the option to choose after pressing RETURN move Left, Right, Up, or Down. I want to go to the first cell in the next row. How do I do that?

 

[CyberTaz]

This 'feature' isn't one that can be turned on/off, & AFAIK it works in 2008
exactly as in previous versions. However, this is one of those "intuitive"
features which performs differently depending on circumstances. You can't
rely on it to always do what you might prefer

To test, use a new sheet in a new workbook. Type content into several cells
of the same row using Tab or Rt Arrow & when you've entered the last item
press return. Does the selector move to the next row beneath the first item
you typed? If so it is working as it should. Note that if you stop anywhere
along the way to fix a typo or whatever that the selector will go to the
next row when you press return but it will be in the column where you
stopped to make the fix. Likewise, if you click in - say - the 3rd column of
a row of data then Tab across the row & press return at the end the selector
will go beneath the cell in which you started.

If you want to dictate what you're expecting on a permanent basis aply the
List Manager (Insert menu) to your data range.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Phillip Jones, C.E.T.]

I've found if start in in a particular way tab, tab, tab the click to
beginning of next row it will follow that pattern unless for some reason
you do an extra tab or (return) click in another cell then it starts
over and you have to re-teach it.

 

[suesailor]

Thanks, it was the "learning" part. I had to re-teach Excel to go down and over to the first column. Thanks for the help.

 

[Y Wilson]

I have found a solution that works in Mac Excel 2011:

If you want to click the RETURN key and have the cursor go from the current cell to the the next row in Column A (i.e. The cursor is in cell B2, click RETURN, the cursor moves to A3) do the following:

1) Click on the Apple logo in the upper left corner of your desktop.

2) Click SYSTEM PREFERENCES.

3) Click KEYBOARD.

4) In the KEYBOARD box click KEYBOARD SHORTCUTS.

5) Click APPLICATION SHORTCUTS from the left menu.

6) Click the + (plus sign) that appears to the left of the Restore Defaults
button.

6) In the box that appears select EXCEL for the APPLICATION you want to apply this shortcut to. (if Excel does not appear on the list, click on OTHER at the bottom of the list, click MICROSOFT OFFICE, then click EXCEL).

7) In the MENU TITLE field enter the name you would like to give this shortcut (i.e. ACTIVE CELL). Click the RETURN key(enter) to continue.

The cursors will now appear in the KEYBOARD SHORTCUT field. Click the RETURN (enter) key once. The shortcut will now appear in the KEYBOARD SHORTCUT field.

9) Click ADD.

Now go into the spreadsheet and test the shortcut. Enter information into the spreadsheet into a number of cells in the same row (move between the cells either with the TAB key or RIGHT ARROW), When you are done entering your information, then click RETURN. The cursor should now move to the next row in COLUMN A (i.e. The cursor is in cell B2, click RETURN, the cursor moves to A3).

Hope it works for you as well as it did for me.

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

When entering data In the 2004 version, when I hit Return, the cursor would go to the next row and the 1st column of the spreadsheet. Now I cannot seem to make it do that in the 2008 edition. In Preferences I have the option to choose after pressing RETURN move Left, Right, Up, or Down. I want to go to the first cell in the next row. How do I do that?

On Wednesday, March 10, 2010 4:56 PM CyberTaz wrote:
This 'feature' is not one that can be turned on/off, & AFAIK it works in 2008
exactly as in previous versions. However, this is one of those "intuitive"
features which performs differently depending on circumstances. You cannot
rely on it to always do what you might prefer

To test, use a new sheet in a new workbook. Type content into several cells
of the same row using Tab or Rt Arrow & when you have entered the last item
press return. Does the selector move to the next row beneath the first item
you typed? If so it is working as it should. Note that if you stop anywhere
along the way to fix a typo or whatever that the selector will go to the
next row when you press return but it will be in the column where you
stopped to make the fix. Likewise, if you click in - say - the 3rd column of
a row of data then Tab across the row & press return at the end the selector
will go beneath the cell in which you started.

If you want to dictate what you are expecting on a permanent basis aply the
List Manager (Insert menu) to your data range.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 3/10/10 2:18 PM, in article (e-mail address removed)2ac0,