PDA

View Full Version : Excel - Cell Selection using TAB



02-10-2001, 08:49 AM
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.

02-10-2001, 09:40 AM
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.