Tab between cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to tab between certain cells in a worksheet and not allow someone to
tab over to any cell they choose...I'm making a form for someone to fill out.
How do I lock the cells so they can only tab over to the cells I want them
to fill out?
 
By default all cells are protected when the worksheet protection is enabled.

Select the cells to tab to and Format>Cells>Protection>Unlock.

Now Tools>Protection>Protect Sheet. At this point if you have xl2002 or newer
you can uncheck the option to "select locked cells" if you choose.

Won't change the tab order, but will keep users from getting any message if they
use the mouse to click on a cell and try to enter data.

Start tabbing.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference the same cell based on tab name 1
Using Tab key to jump to specific cell 2
How do I set up worksheet to keep tabs from being deleted? 1
Excel Macro to automatically go to the right of the last colored cell 0
Locked cells tabbing? 2
attempting to format a color pattern in tab 3, based tab 2 and tab 5
Tabbing between cells in Excel 3
Displaying zeros in cells 2

Back
Top