Skipping Columns/Rows


L

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!!
 
Ad

Advertisements

B

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top