Thanks for your help, I did try to explain to the person that I was working
with that the enter key would work however that didn't work for him.

I found a way to do it with using locked and unlocked cells and adding sheet
protection.

"Jim Rech" wrote:

Alternatively, if you select the range first like A1:D10 then you can Tab is
each cell, across rows first.

--
Jim
"Erika" wrote in message
...
|I have a spreadsheet that is 4 columns wide, I want to be able to tab to
each
| cell and when I reach the 4th cell in each row when I push tab I want it
to
| go to the next row
|
| Is that possible? I have tried hiding the remaining columns, deleting the
| remaining columns and had no luck
|
|