• Select Locked Cells (bug?) (2002)

    Author
    Topic
    #408795

    Lately I have been using the shortcut key ctrl+pgup and ctrl+pgdn to move between worksheets. I think I

    Viewing 1 reply thread
    Author
    Replies
    • #866348

      I hadn’t noticed, but you’re right – Ctrl+PageUp and Ctrl+PageDown work differently in a protected worksheet if selecting locked cells is off. Another pair of keys that works differently is Home and End – they select the first and last unlocked cell, respectively. There is no “End mode” (pressing End followed by an arrow key has no effect)

      • #866381

        Thanks for the confirmation. Didn’t know about the home and end keys but fortunately no big show stoppers.

      • #866382

        Thanks for the confirmation. Didn’t know about the home and end keys but fortunately no big show stoppers.

    • #866349

      I hadn’t noticed, but you’re right – Ctrl+PageUp and Ctrl+PageDown work differently in a protected worksheet if selecting locked cells is off. Another pair of keys that works differently is Home and End – they select the first and last unlocked cell, respectively. There is no “End mode” (pressing End followed by an arrow key has no effect)

    Viewing 1 reply thread
    Reply To: Select Locked Cells (bug?) (2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: