Press "Return" and go to row below Column A

[sammanfa]

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

In some of my spreadsheets, when I press "Return" at the end of the row, it brings me to the cell right below my current cell.
How can I change it so that when I press "Return" it will take me to the row below at column A (the start of the row)?

 

[CyberTaz]

Excel tries to work that way all the time, but you have to "cooperate" a
little Use the Tab or Shift+Tab to navigate horizontally rather than
using the L/R arrow keys & you should find that when you get to the last
column of your data range the return key will take you to the first column
in the next row. It can be a little spotty in an established data range
dependent on which column you start.

You can also use the Insert> List Wizard to convert your data range to a
List, which enables tabbing throughout the list just as though it were a
Table in Word - Tab at the end of the row wraps you to the start of the next
row. Investigate Lists in Help if you choose to use the feature because it
has some limitations in addition to other advantages.

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

 

[sammanfa]

i've done that tab all the way through and even when i press return it still doesn't return to column A of the next row tried the list thing, i don't like how it changes and looks different from normal cells. is there any other way to get to column A of the next row just by entering?

Excel tries to work that way all the time, but you have to "cooperate" a

 

[CyberTaz]

In order for that to work the data has to start in column A & be in
consecutive columns from left to right. Also, if you don't begin in the
first column of the data, return will only go back as far as the column you
started in. Other than the List feature I don't know of any way to change
the behavior.

I'm not sure what you mean about the list, though, because the "Visuals" &
"AutoFilter" can be toggled off any time you wish. The only "permanent"
change is the pale gray border that delineates the extent of the list.

If your data actually starts in column A or if you want to go to column A
after pressing return you can press Home or Cmd+LeftArrow.

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