Forum Home
Press F1
Thread ID: 11661	2001-10-01 20:49:00	Excel - Cell Selection using TAB	Guest (0)	Press F1

Post ID	Timestamp	Content	User
19758	2001-10-01 20:49:00	I am using Excel for teachers to write pupil reports (a long story why we use Excel!). I have unlocked specific cells where comments and grades are to be entered, and I have protectes the worksheet to the TAB key only goes to the required cells. I would like to be able to determine the order of cells whichthe TAB key takes the user to (as in Access); not just up or down, but more like across-down-down-across. Is this possible? Thank you.	Guest (0)
19759	2001-10-01 21:40:00	The Excel Tab default will go to the unlocked cells to the right in the same row then down to the first unlocked cell in the next row containing an unlocked cell. Your best bet may be to construct the placing of the unlocked cells on the worksheet to accommodate the default Tab characteristic.	Guest (0)
1