G Guest Jan 13, 2005 #1 How do I configure a spreadsheet to skip columns when I am tabbing across for data entry? Thank you Bill Nash
How do I configure a spreadsheet to skip columns when I am tabbing across for data entry? Thank you Bill Nash
N Nick Hodge Jan 13, 2005 #2 Bill Select the columns you want to tab to and then do format>Cells...>protection>locked - uncheck Now go to Tools>Protection>Protect sheet... It will now only tab to the unlocked cells -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
Bill Select the columns you want to tab to and then do format>Cells...>protection>locked - uncheck Now go to Tools>Protection>Protect sheet... It will now only tab to the unlocked cells -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
G Gord Dibben Jan 13, 2005 #3 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
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
