R
rjohnson1977
how do you set tabs in excel to move to specific cells?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tyro
Excel does not have tabs, such as Word's tabs.
Tyro
Tyro
M
Mike Rogers
rjohnson1977
The sequence of movement using the tab key can be only from left to right
through columns then down to the next row. But you can have it only go to
certian cells for adding data. The cells on a sheet are by default "Locked",
you can unlock the ones used for data entry and "Protect" the worksheet and
the tab key will advance you through those "Unlocked" cells.
To do this goto>format>cells>protection>remove the check mark from "Locked".
Now goto>tools>protection>protect sheet. You do not have to use a password
but can if it is appropriate.
Now when you move through your worksheet with the tab key it will only go to
those unlocked cells. Again I know of no way to change the pattern of
movement, it is left to right through the columns then down to the next row
with unlocked cells and again left to right.
I hope this helps you
Mike Rogers
The sequence of movement using the tab key can be only from left to right
through columns then down to the next row. But you can have it only go to
certian cells for adding data. The cells on a sheet are by default "Locked",
you can unlock the ones used for data entry and "Protect" the worksheet and
the tab key will advance you through those "Unlocked" cells.
To do this goto>format>cells>protection>remove the check mark from "Locked".
Now goto>tools>protection>protect sheet. You do not have to use a password
but can if it is appropriate.
Now when you move through your worksheet with the tab key it will only go to
those unlocked cells. Again I know of no way to change the pattern of
movement, it is left to right through the columns then down to the next row
with unlocked cells and again left to right.
I hope this helps you
Mike Rogers
D
Dave Peterson
Select your range to do the data entry first.
Then you can tab through the selected cells in that range.
If you have to do it lots of times, you can name the range.
Select the cells (start with cell 2, then cell 3, ... and finish up with cell
1)
Insert|Name|Define
Then just select that named range when you want to tab through the range.
Then you can tab through the selected cells in that range.
If you have to do it lots of times, you can name the range.
Select the cells (start with cell 2, then cell 3, ... and finish up with cell
1)
Insert|Name|Define
Then just select that named range when you want to tab through the range.
M
Mike Rogers
Dave
I like it!!! Simple things to learn, Valuable things to have. Thanks
Mike Rogers
I like it!!! Simple things to learn, Valuable things to have. Thanks
Mike Rogers