| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to specify order of moving to unlocked cells in a protected sh
I have unlocked cells for data entry, then protected my sheet. When I start
at the first entry point and arrow down, it goes to the second then jumps down several. I want to make it easy for data enterers so it goes down the sheet in order. Help? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to specify order of moving to unlocked cells in a protected sh
When tabbing between unlcocked cells, XL follows the convention of
left-to-right, then top-to-bottom. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mwood" wrote: I have unlocked cells for data entry, then protected my sheet. When I start at the first entry point and arrow down, it goes to the second then jumps down several. I want to make it easy for data enterers so it goes down the sheet in order. Help? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Viewing of protected locked or unlocked cells | Excel Worksheet Functions | |||
| How to delete the content of all unlocked cells in a protected she | Excel Discussion (Misc queries) | |||
| Unlocked Cells in Protected Sheet | Excel Worksheet Functions | |||
| Moving from unlocked cells to unlocked cells in an excel form | Excel Worksheet Functions | |||
| move between unlocked cells on protected sheet | Excel Discussion (Misc queries) | |||
Linear Mode
