Cell to cell
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Cell to cell

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    155
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    have a worksheet that certain cells needs to be filled with info, but would like to know of a way to get to those cells without using the mouse or arrows to get from one specific cell to the others to imput data. Using the tab key would work to jump from one designated cell to the other.

    Thanks..Roy

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Roy

    You could try this:
    Moving left to right. Skip the first cell then select the others holding down the control key, then select your first cell.
    Release the control key (cells remain selected). Type data for your first cell then press enter, type data for your second cell then press enter. Data will enter your selected cells one column at a time, moving left to right.
    hope this helps
    regards
    Derek

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Guderup, Denmark
    Posts
    288
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You could format your jumpcells as unproteced.
    then protect the sheet.
    now the TAB-key will switch only between the unprotected cells
    regards Tommy

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com