ozziewendy
New Member
I used to be able to enter data in a row in an Excel spreadsheet by tabbing across cells, then when I was finished and hit enter the focus would move to the first cell in the next row (or the cell in the next row underneath the one where I first started tabbing across).
So:
Start in A1, tab, tab, tab, Enter
Focus moves to B1
Now all my new spreadsheets don't behave this way. Instead, hitting Enter only moves the focus down/up/left/right one cell, depending on what option I have selected.
So:
Start in A1, tab, tab, tab, Enter
Focus moves to B4
I have found various hints on the net, but none of them really work for what I want to do.
Hint 1: make the cells a table. The trouble is, there are 20 possible cells to enter data into, but in the vast majority of cases I only want to enter into the first couple of cells in a row. I actually already have the sheet protected so only those first 20 are unlocked, but I don't want to have to tab across the entire row each time.
hint 2: Select only those cells that you are going to enter the data into. Unfortunately I have some locked columns amongst the unlocked ones, and I can't make a selection across these.
All I want is for my new spreadsheets to work in the same way as the old ones!
So:
Start in A1, tab, tab, tab, Enter
Focus moves to B1
Now all my new spreadsheets don't behave this way. Instead, hitting Enter only moves the focus down/up/left/right one cell, depending on what option I have selected.
So:
Start in A1, tab, tab, tab, Enter
Focus moves to B4
I have found various hints on the net, but none of them really work for what I want to do.
Hint 1: make the cells a table. The trouble is, there are 20 possible cells to enter data into, but in the vast majority of cases I only want to enter into the first couple of cells in a row. I actually already have the sheet protected so only those first 20 are unlocked, but I don't want to have to tab across the entire row each time.
hint 2: Select only those cells that you are going to enter the data into. Unfortunately I have some locked columns amongst the unlocked ones, and I can't make a selection across these.
All I want is for my new spreadsheets to work in the same way as the old ones!