How to go to next row first column
sues...@officeformac.com
CyberTaz
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 59bb4...@webcrossing.JaKIaxP2ac0,
Phillip Jones, C.E.T.
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 59bb4...@webcrossing.JaKIaxP2ac0,
> "sues...@officeformac.com"<sues...@officeformac.com> 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"
http://www.phillipmjones.net http://www.vpea.org
mailto:pjo...@kimbanet.com
sues...@officeformac.com
Y Wilson
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. 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 59bb4...@webcrossing.JaKIaxP2ac0,
>>> On Wednesday, March 10, 2010 8:24 PM Phillip Jones, C.E.T. wrote:
>>> I have found if start in in a particular way tab, tab, tab the click to
>>> Phillip M. Jones, C.E.T. "If it is Fixed, Don't Break it"
>>>> On Thursday, March 11, 2010 12:36 AM suesailo wrote:
>>>> 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.
>>>> Submitted via EggHeadCafe
>>>> Microsoft ASP.NET For Beginners
>>>> http://www.eggheadcafe.com/training-topic-area/ASP-NET/7/ASP.aspx