Changing Tab Order
Posted by Becky S. on August 17, 2001 12:14 PM
I have an excel worksheet in which I would like to change the tab order. For instance, instead of going from cell A1 to cell B1 upon hitting tab, I would like it to go from cell A1 to cell C1. Does anyone know of a way to do this?
Posted by phillip on August 17, 2001 12:14 PM
Just DRAG them
Posted by phillip on August 17, 2001 12:24 PM
Oops. My bad. I thought you were talking about Worksheet Tabs. I don't know how to do what you want....except maybe hit"tab" twice ?
Posted by lenze on August 17, 2001 12:45 PM
It sounds like you may have a form you wish to navigate. If so, you should lock all cells on the sheet (Format>Cell>Protection Tab) and then unlock cells you want to be able to change or enter data in. Then, protect the worksheet. Now the TAB key will move from one unlocked cell to the next, skipping the locked ones.
Posted by lenze on August 17, 2001 12:45 PM
It sounds like you may have a form you wish to navigate. If so, you should lock all cells on the sheet (Format>Cell>Protection Tab) and then unlock cells you want to be able to change or enter data in. Then, protect the worksheet. Now the TAB key will move from one unlocked cell to the next, skipping the locked ones.
