Results 1 to 2 of 2
  1. #1

    Default Excel - Cell Selection using TAB

    I am using Excel for teachers to write pupil reports (a long story why we use Excel!). I have unlocked specific cells where comments and grades are to be entered, and I have protectes the worksheet to the TAB key only goes to the required cells.

    I would like to be able to determine the order of cells whichthe TAB key takes the user to (as in Access); not just up or down, but more like across-down-down-across.

    Is this possible?

    Thank you.

  2. #2

    Default Re: Excel - Cell Selection using TAB

    The Excel Tab default will go to the unlocked cells to the right in the same row then down to the first unlocked cell in the next row containing an unlocked cell.

    Your best bet may be to construct the placing of the unlocked cells on the worksheet to accommodate the default Tab characteristic.

Similar Threads

  1. Telecom Cell Phone Selection (Hopeless)
    By Marshman in forum PC World Chat
    Replies: 16
    Last Post: 30-04-2007, 01:23 PM
  2. Excell (cell selection)
    By in forum PressF1
    Replies: 6
    Last Post: 03-02-2002, 07:27 AM
  3. excel cell selection
    By in forum PressF1
    Replies: 2
    Last Post: 14-08-2001, 10:36 PM
  4. Excel Jump to Cell 'xy' feature
    By in forum PressF1
    Replies: 0
    Last Post: 12-09-2000, 02:22 PM
  5. Replies: 0
    Last Post: 09-10-1998, 11:19 PM

Posting Permissions

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