



I did that - and it got me half way there. Well, they kept that hidden! Thanks for the tip. It would still be nice if this was user selectable This probably explains - but in my view does not excuse - the combining of the Return and Enter keys into the same function leaving the tab key to do what the enter key used to do! The return key is in the same physical location as on the laptop keyboard but the enter key is at the bottom right of the numeric section. There is one other thing which might explain the change - which is in laptops the return and enter keys are physically the same. Although having checked it out and selected Move Down after pressing the return key, repeatedly pressing the return key on a protected spreadsheet with locked cells the active cell still moves through the locked cell - it doesn't skip it. I should have mentioned that I'm using an external (full) keyboard (since the laptop keyboard does not have a "proper" numeric key pad).Īlso, I presume in Excel preferences you have selected what to do after the return key is pressed. Hi - thanks for taking the trouble to reply.

If not I believe Microsoft should quickly revert to the old way or at least make the functions of these keys a user selectable option Has anyone else experienced this drawback and does anyone have a solution? This - in my opinion - is a huge backward step for Excel. In the new version only the tab key will do this with the enter key now being paired with the return key which cannot perform the old function. you could press number, enter, number, enter, number, enter, etc etc safe in the knowledge that each time you pressed Enter the active cell would simply skip over the locked cells (with formulas etc) and stop at the next cell waiting for the number/data (whatever) to be entered. Each time the enter key was pressed the active cell would move to the next cell SKIPPING the locked cells. This was extremely useful for entering data into a protected spreadsheet. In my old version of Excel for Mac, the enter and tab keys had the same function with the return key having a separate function.
