Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a file that is Protected by Tools -- protection, with the Select
Unlocked Cells checked and the Select Lock Cells Not checked. When I am in a group of unlocked cells, I can move from cell to cell using the right and left arrow, but not the up and down arrow. I can select any unlocked cell in that group with the mouse, but not the arrow keys. If I unprotect the cell, then the arrows work fine. Does anyone have any ideas? Everything worked fine earlier this week, but today it does not. Please help!!!! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Josh - I'm searching this site because I'm having the same problem. If you
check, I'll bet you can Tab through your cells, but just not arrow up or down. Similarily, Enter will not move your selection. If I protect my sheet with "Select Locked Cells" selected, I can arrow, enter, and tab just fine. Similar sheets in the same workbook do not have this problem. I'm echoing your plea for help, here. Anybody, any ideas? "Josh C" wrote: I have a file that is Protected by Tools -- protection, with the Select Unlocked Cells checked and the Select Lock Cells Not checked. When I am in a group of unlocked cells, I can move from cell to cell using the right and left arrow, but not the up and down arrow. I can select any unlocked cell in that group with the mouse, but not the arrow keys. If I unprotect the cell, then the arrows work fine. Does anyone have any ideas? Everything worked fine earlier this week, but today it does not. Please help!!!! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am sorry to say that I have not found a fix yet, so can anyone please help
us???? "Friemark" wrote: Josh - I'm searching this site because I'm having the same problem. If you check, I'll bet you can Tab through your cells, but just not arrow up or down. Similarily, Enter will not move your selection. If I protect my sheet with "Select Locked Cells" selected, I can arrow, enter, and tab just fine. Similar sheets in the same workbook do not have this problem. I'm echoing your plea for help, here. Anybody, any ideas? "Josh C" wrote: I have a file that is Protected by Tools -- protection, with the Select Unlocked Cells checked and the Select Lock Cells Not checked. When I am in a group of unlocked cells, I can move from cell to cell using the right and left arrow, but not the up and down arrow. I can select any unlocked cell in that group with the mouse, but not the arrow keys. If I unprotect the cell, then the arrows work fine. Does anyone have any ideas? Everything worked fine earlier this week, but today it does not. Please help!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Up & Down Arrows | Setting up and Configuration of Excel | |||
Up/down arrows | Excel Discussion (Misc queries) | |||
Arrows in pie chart | Excel Discussion (Misc queries) | |||
Up Arrows / Down Arrows | Excel Worksheet Functions | |||
Getting rid of drop down arrows | New Users to Excel |