Hi

Just to add to answers you have received, you might want to look at
Tables in XL2007.
They will allow you to do just what you want, in terms of "bouncing"
back to the beginning of the next row, once you have entered data in the
last column.

Place your cursor anywhere inside your list of data, and choose Insert
tabTable
If you have any formulae in your table, they will automatically be
created as you add new rows, and the dimensions of the table will grow
and shrink automatically as you add more rows or delete rows.
As with many of the new Ribbon tabs, you will find additional Tools. If
you click on a cell within your table, then on the top row of the screen
you will see Table Tools, which will provide you with many more options,
including the facility to turn the table back to a straightforward List.

There is also a downloadable add-in from Microsoft, which puts another
tab on your ribbon with lots of useful help when trying to get to grips
with the new Ribbon layout
http://snipurl.com/1jr7e

This includes an interactive guide where you can see a 2003 layout,
hover over the command and it will show you where that is now located.
Click on the command and the screen changes to XL2007 with the area of
the Ribbon highlighted.
That can be found separately, without installing the add-in if required,
at
http://office.microsoft.com/en-us/ex...491511033.aspx


--
Regards

Roger Govier


"Diamontina Cocktail" wrote in message
...
Until I know more about Excel in general, all I can say with 2007
version if you haven't used it yet is that the right click menu is
invaluable. The ribbon takes some searching when you aren't used to
the program much but the right click menu often solves that problem.


"Don Guillett" wrote in message
...
I also have not yet installed my 2007. Have you tried the HELP index
for PROTECTION?

--
Don Guillett
SalesAid Software

"Diamontina Cocktail" wrote in message
...

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
couple of ways to do this.

1. Select columns A:K and FormatCellsProtectionclear the
checkmark in
"Locked"

Thanks, that worked but not exactly as you said it. I use Excel
2007.


ToolsProtectionProtect sheet.


There is no "Tools" menu in Excel 2007 that I could find.

You can Tab your way across and when you leave K1 you will drop to
A2

2. Without protection...........Start in A1 and Tab your way
across. When
leaving K1 hit the ENTER key.

I actually always do that anyway and it didnt produce that effect.