How To Go To Next Line In Excel For Mac

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? Flux software for mac download. 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.

Most users won't ever need to enter a line break in an Excel spreadsheet cell - but if you do - it's not as easy as you might think! Simply hitting the enter key makes Excel jump to the next cell.

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 On 3/10/10 2:18 PM, in article 59bb475b.-1@webcrossing.JaKIaxP2ac0, Phillip Jones, C.E.T. 10/3/2010, 17:24 น. 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. CyberTaz wrote: > 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 > > > > On 3/10/10 2:18 PM, in article 59bb475b.-1@webcrossing.JaKIaxP2ac0, > ' wrote: > >> 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? > -- Phillip M. Jones, C.E.T. 'If it's Fixed, Don't Break it' mailto: sues.@officeformac.com 10/3/2010, 21:36 น.

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. > On Wednesday, March 10, 2010 2:18 PM suesailo wrote: > 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.