+ Reply to Thread
Results 1 to 2 of 2

Worksheet- avoiding cells

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    1

    Worksheet- avoiding cells

    I am creating a worksheet where I need to be able to tab only to certain cells leaving the other cells untouched. Is there a way to do this? Basically it is a script in which I need certain cells to be edited by the user of the worksheet, but to save time I want them to be able to tab only to the cells that they need to input information in. I can't seem to figure this out. Any help or suggestions are appreciated.

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    For the cells for which you would like the user to use Tab to go to the next cell, go to Format > Cells, and uncheck Locked, then protect the sheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1