Use Tab to get to next line
 

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

Use Tab to get to next line
 

Hi Erika,

Try
Tab Tab Tab Enter
Tab Tab Tab Enter
etc.

HTH
Martin


"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

Use Tab to get to next line
 

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

Use Tab to get to next line
 

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