Forum Discussion

KMadhan1983's avatar
KMadhan1983
Copper Contributor
Apr 22, 2019
Solved

issue in Selecting cells using Shift + downward arrow

Hi, earlier I used to select the cells having values using Shift + downward arrow / side ward arrows. If i need to select 100 cells which is having values in one click (vertical), i used to click 1st...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 22, 2019

    KMadhan1983 , the only setting I know - this one shall be unchecked

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 22, 2019

KMadhan1983 , to select entire range till first blank cell that's Ctrl+Shift+ArrowDown.  Select current and next cell that's Shift+ArrowDown. IMHO, that was all the time.

  • KMadhan1983's avatar
    KMadhan1983
    Copper Contributor
    Apr 22, 2019

    SergeiBaklan Thanks for your reply.

     

    And really sorry that instead of mentioning Shift+Ctrl+Arrow Down I have written Shift+Arrow Down.

     

    Shift+Ctrl+Arrow Down to select the entire range is not working for me. Is there anything in settings I need to do changes? Please suggest.

    Thanks

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 22, 2019

      KMadhan1983 , the only setting I know - this one shall be unchecked

       

      • KMadhan1983's avatar
        KMadhan1983
        Copper Contributor
        Apr 22, 2019

        Thank you so much SergeiBaklan

        It's working properly now.

         Thank you once again

Resources