Cell to cell

royhern · Mar 22nd, 2002, 04:38 AM

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 · Mar 22nd, 2002, 04:48 AM

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 · Mar 22nd, 2002, 05:38 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 04:38 AM	#1
royhern Board Regular Join Date: Feb 2002 Posts: 155	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

Mar 22nd, 2002, 04:48 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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

Mar 22nd, 2002, 05:38 AM	#3
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	You could format your jumpcells as unproteced. then protect the sheet. now the TAB-key will switch only between the unprotected cells regards Tommy