Excel 2003 - is there way to tab from field to field on simple fo

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lisa M - 23 Aug 2006 22:53 GMT

I have a user who is trying to make a very simple form on an excel
spreadsheet --mostly text boxes, a check box or two. She finds that she can't
tab from field to field, though -- the cursor goes from cell to cell. I find
I can only tab from field to field in design mode -- are we missing
something easy?

Signature

Lisa M

Reply to this Message

Kurt - 24 Aug 2006 00:34 GMT

If you unlock the cells you wish to allow to be edited and protect the
worksheet, you will tab between editable cells. I'm not sure if there is a
way to set the tab order. By default its across first then down to the next
row.

...kurt

>I have a user who is trying to make a very simple form on an excel
> spreadsheet --mostly text boxes, a check box or two. She finds that she
[quoted text clipped - 3 lines]
> I can only tab from field to field in design mode -- are we missing
> something easy?

Reply to this Message

Lisa M - 24 Aug 2006 02:10 GMT

Thanks, Kurt!!!

Signature

Lisa M

> If you unlock the cells you wish to allow to be edited and protect the
> worksheet, you will tab between editable cells. I'm not sure if there is a
[quoted text clipped - 10 lines]
> > I can only tab from field to field in design mode -- are we missing
> > something easy?

Reply to this Message

Suebriquet - 26 Jul 2007 14:36 GMT

Kurt, I think this was my enquiry Lisa referred to. I'm familiar with
unlocking cells for form fill-in protection. But the check box form fields
just float over the cell location. If you land on the cell in the normal form
tab progression you can't use the space bar to check the box - anything you
enter just affects the underlying cell. Is there a way to have the check box
replace the cell?

Sue

Reply to this Message