Use Tab to get to next line

E

Erika

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
 
J

Jim Rech

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

--
Jim
|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
|
|
 
E

Erika

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.
 
Top