Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#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 wrote: How do I configure a spreadsheet to skip columns when I am tabbing across for data entry? Thank you Bill Nash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |