limited data entry

[dondepew]

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

 

[Epinn]

Does Data>Form serve your purpose?

http://www.contextures.com/xlDataEntry01.html#List

Epinn

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

 

[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