Skipping Columns/Rows

[Lilbit]

Is it possible to skip a column or row when tabbing in a workbook? In
other words, when I'm in A1 and I hit the tab key, I want to be in C1.

P.S. -- I do not want to hide the columns as I'm an advocate of using the
least amount of steps as necessary to produce a document. In other words,
I do not want to hide, enter data, unhide, print, receive additional data,
hide, enter data, unhide, print, and so on and so on.
Thanks!!

 

[Bernie Deitrick]

Lilbit,

Format columns A and C to be unlocked (on the protection tab of the format dialog).

Then protect the sheet, and allow selection of unlocked cells only.

Then when you tab, you will go from A1 to C1 - from one unlocked cell to the next, skipping B1,
which is still locked.

May work in Excel 2000 (I forget when they added the selection options when protecting a sheet),
definitely works in Excel XP and on.

HTH,
Bernie
MS Excel MVP

 

[Lilbit]

Thanks so much. It worked like a charm!!!