limited data entry

D

dondepew

Would like to limit data entry to 5 columns and automatically position to
first column in the next row to continue entries.
 
G

Gord Dibben

Select columns A:E and Format>Cells>Protection and de-select "locked"

Tools>Protection>Protect sheet. Uncheck "select locked cells" and OK. Set a
Password if you require one.

Then Tools>Options>Edit. Set "move selection after enter" to right or use the
Tab key to move to next cell across.

When you leave column E you will go back to A and down one row.


Gord Dibben MS Excel MVP
 
Top