Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
How do I make certain cells non-accessable? I would like to have the
worksheet so that only certain cells can be clicked and edited, but when you press enter, tab, or arrows the curser continues to the next "available" cell. |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
You need to highlight the cells you want to access and then go to
FormatCells...Protection and un-check locked. Now go to ToolsProtectionProtect Sheet... and select any options you want here. Now pressing tab will cycle to the un-locked cells -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "robrockk" wrote in message ... How do I make certain cells non-accessable? I would like to have the worksheet so that only certain cells can be clicked and edited, but when you press enter, tab, or arrows the curser continues to the next "available" cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
Making cells show nothing | Excel Worksheet Functions | |||
Blank cells in named range- how to ignore them when making my graph? Help plz! | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
making cells adjust | Excel Discussion (Misc queries) |