Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Problem

I have an Excel spreadsheet that is locked except for some cells where I want a user to enter text. Pressing Tab or Enter jumps to the next unlocked cell just fine in most cases except for in one case where, after pressing enter, the selected cell jumps to the top of the sheet instead of selecting the cell just below.

Useful Tidbits

  • I have a bunch of named ranges (don't know if that's relevant)
  • The problem does not span across a page break.
  • The problem occurs every time I lock the sheet and try to tab/arrow key/enter from row 41 to 42. It's almost as if there is a hidden page break there!
  • It always jumps to the topmost unlocked cell.
share|improve this question

migrated from stackoverflow.com Dec 13 '12 at 6:02

This question came from our site for professional and enthusiast programmers.

    
@JMK Ok. Is there a way to migrate it to SuperUser? –  Jesse Dec 12 '12 at 20:06
2  
@Senoculus: you don't have to worry about it. Users with 5k+ reputation can vote to migrate your question (or a mod with a diamond in his/her name can do it right away). Your question might move at a time or another to superuser, this is normal –  JMax Dec 12 '12 at 20:32
add comment

1 Answer 1

I've had this problem before. Does this happen to be the last unlocked row with data ?

If that's the case, then here's what I noticed : it seems that when limiting users to unlocked cells, Excel will also create a "box" with corners being the last rows and columns where data exists. This is not the best explanation, but see on my question if that better answers your question:

Locking cells for selection : wrong behaviour

share|improve this answer
    
Thanks for the answer. I would be ok with excel jumping to the top once it got to the bottom of the sheet, but it is jumping prematurely. For example: In the link you posted, you have 3 sections (A and D are unlocked, and section C is locked). The behavior I am experiencing is that using the keyboard arrows, the selected cell would cycle through all unlocked cells in section A, and then instead of jumping over section C to section D, it would start back at the beginning of section A. The only way to get to section D is to use the mouse and click. –  Jesse Dec 13 '12 at 20:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.