Navigating through cells

  • Thread starter Thread starter gram
  • Start date Start date
G

gram

I want to create a form and want to skip cells: Like
navitgate from A1 to F8 in one stroke. Can I do that?
 
Gram

I think you want the form to just be a spreadsheet. In
that case select the celss that you want to re-use for
data entry and choose, Format, Cells and on the protection
tab deselect the Locked checkmark and click OK

Now choose Tools, Protection and protect the worksheet.
You should be able to use the Tab key to jump between data
entry cells. Now save the workbook.

Remember that if you apply a password it is Case Sensitive
and you will be unable to use the worksheet if you forget
the password.

Regards
Peter
 
Back
Top