Forum Discussion

loren meyer's avatar
loren meyer
Copper Contributor
Sep 24, 2018
Solved

Excel Issue: 3 keys and one hand?

Sounds like a riddle?  It is, for me.  I need help. I am taking a course in school where I have to use Ctrl+Shift+Enter (to work with matrixes) in Excel.  I have poor control of my right fingers due to nerve damage.  So, hitting all three keys, at the same time is difficult! I get it, one time in 20!  So I am getting a lot of !#VALUE instead of my result.  Is there a way I can do this by hitting a single key?  

  • Hi Loren,

     

    It's easy!

    You don't have to press three keys at the same time!

    Just press Ctrl and keep your finger on it, then press Shift and also keep your finger on it, then press Enter.

    After you press Enter, lift your fingers up.

     

    Hope that helps

3 Replies

  • I'm moving this conversation to the Excel space for better visibility.

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi Loren,

     

    It's easy!

    You don't have to press three keys at the same time!

    Just press Ctrl and keep your finger on it, then press Shift and also keep your finger on it, then press Enter.

    After you press Enter, lift your fingers up.

     

    Hope that helps

    • loren meyer's avatar
      loren meyer
      Copper Contributor

      I will try it!  Thanks so much.  I have a test tonight and was so worried about this.  I will let you know what happens. 

Resources