Cell to cell

[royhern]

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

 

[Derek]

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

 

[Tommy Bak]

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