Home |
Search |
Today's Posts |
#1
|
|||
|
|||
navigational keys in protected sheets
I have two sheets in the same purchase order workbook. Second sheet is same
as first with some additional cells locked. The navigational keys work fine when the sheets are unprotected. When I protect the two sheets, the keys continue to work fine on the first sheet. But on the second page the tab and left/right arrows will only work within the same row and will not go to next cell in next row. The Enter and up/down arrows do not work at all. The area that I'm working with is identical in both sheets. To input data on the second sheet, you have to keep using the mouse to go to the needed cell in each row. Why does one sheet work and the next doesn't? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula auditing on protected sheets | Excel Discussion (Misc queries) | |||
Index of protected sheets | Excel Worksheet Functions | |||
grouping of cells in protected sheets | Excel Worksheet Functions | |||
Can't open protected sheets | Setting up and Configuration of Excel | |||
Protected sheets | Excel Worksheet Functions |