Home |
Search |
Today's Posts |
#1
|
|||
|
|||
strange scrolling in Excel 2003
I have a protected worksheet on which users cannot "select locked cells."
However, with this protection on, the keyboard arrow keys now scroll through the far left and top of the worksheet - hitting up in row 1 takes you to the last row - hitting left in column A takes you to the last column. How can I stop this? |
#2
|
|||
|
|||
I tried this in xl2002 and could only duplicate it if the lastrow (65536) was
unlocked. (Did you mean last row of the worksheet or last row of the unlocked cells?) If you meant that excel took you to the "next" available cell, then this seems like a pretty good design choice to make data entry easier. (My guess, anyway.) Ryan wrote: I have a protected worksheet on which users cannot "select locked cells." However, with this protection on, the keyboard arrow keys now scroll through the far left and top of the worksheet - hitting up in row 1 takes you to the last row - hitting left in column A takes you to the last column. How can I stop this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
Stock Quotes in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 97 to Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |