G Guest Feb 8, 2007 #1 Would like to limit data entry to 5 columns and automatically position to first column in the next row to continue entries.
Would like to limit data entry to 5 columns and automatically position to first column in the next row to continue entries.
E Epinn Feb 8, 2007 #2 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.
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.
G Gord Dibben Feb 8, 2007 #3 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
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
