skipping over cells with enter or tab

**conductorbob** · 01-12-2007, 01:15 PM

Hi OL Great Helpers

I have a Worksheet I Insert Info starting from (B1 to N1) then I need to SKIP over cells (O1,P1,Q1)then INSERT IN (R1) SKIP over (S1) Insert info in
(T1,U1) SKIP (V1) Insert in (W1) SKIP (X1,Y1) the cells I SKIP have
formulas in them,and do it again in B2,B3 etc:. I have tried the locking cells & unlocking the others, it didn't work.I also tried the (Ctrl) game well it didn't work, sorry .
I think I need some kind of code for this. (OR) should I just skip them my self HE HE

CAN YOU HELP
THANKZ
Conductor Bob

**Carim** · 01-12-2007, 01:23 PM

Hi,

One quick way is to Insert Name Define ... and give a name to your input range ...
Then
use F5 type this name and use TAB to jump and .. skip ...

**conductorbob** · 01-12-2007, 02:04 PM

tried it not working I must not being doing it right
How do I send a ZIP file

**Carim** · 01-12-2007, 02:10 PM

If you do not mind, just upload a zipped copy of your worksheet ...

**teelim** · 01-14-2007, 02:12 PM

how about hiding the columns you do not need?

**MSP77079** · 01-14-2007, 02:39 PM

Building on teelim's very practical suggestion ... if you are doing this often, consider using Data >> Group and Outline >> Group to group the columns you want to temporarily skip over.

This makes it very easy to hide and unhide those columns.