How do I skip columns when tabbing in Exce?
 

How do I configure a spreadsheet to skip columns when I am tabbing across for
data entry?

Thank you
Bill Nash

Bill

Select the columns you want to tab to and then do
formatCells...protectionlocked - uncheck

Now go to ToolsProtectionProtect sheet...

It will now only tab to the unlocked cells

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Bill Nash" <Bill wrote in message
...
How do I configure a spreadsheet to skip columns when I am tabbing across
for
data entry?

Thank you
Bill Nash

Protect the columns then protect the sheet.

For more details see Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0008.html


Gord Dibben Excel MVP

On Thu, 13 Jan 2005 10:17:03 -0800, Bill Nash <Bill
wrote:

How do I configure a spreadsheet to skip columns when I am tabbing across for
data entry?

Thank you
Bill Nash