ExcelBanter - Can you make a tab entry form in excel like you can in word

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can you make a tab entry form in excel like you can in word (https://www.excelbanter.com/excel-worksheet-functions/116482-can-you-make-tab-entry-form-excel-like-you-can-word.html)

lmart

Can you make a tab entry form in excel like you can in word

I have created tab entry forms in word, is it possible to create these in
excel?

KePaHa

Can you make a tab entry form in excel like you can in word

Yes, create the form, then those cells which should remain active for data
entry, highlight them, Format Cells, Protection, Unlock them. Then Tools,
Protect, Protect Worksheet. Then the user can Tab from Unlocked cell to
Unlocked cell.

"lmart" wrote:

I have created tab entry forms in word, is it possible to create these in
excel?

All times are GMT +1. The time now is 12:51 PM.