Forum Discussion

JLH64's avatar
JLH64
Copper Contributor
Oct 01, 2019

Ctrl+A Not Selecting All Columns in Spreadsheet

Hi -

 

I'm attempting to select all the cells (with data) in a spreadsheet. No matter what I try, only the first 5 columns are selected. Any suggestionw?

  • JLH64 

    You need to stay within the range to select with Ctrl+A the data only , i.e. some data shall be to the right and down from your focused cell. Otherwise Ctrl+A selects entire sheet.

    • RodBirtles's avatar
      RodBirtles
      Copper Contributor
      Hi Sergei
      I have a similar problem. My sheet is on Sharepoint, but I have downloaded and opened in excel and get the same problem. Ctrl A only picks up rows 1 - 53 out of 87 rows. There is data in every row. CTrl A twice picks up whole sheet. Ctrl end selects the bottom right cell of the data area.
      I have added new data on two occasions and will need to add more, so I think that the filter is only picking up the first set of entries. However I haven't had this problem before.
      Whatever I try, I can't remove the filter. Mostly the sort & filter button is greyed out.
      I have tried copying and pasting the data into another sheet but it behaves exactly the same way.
      Any thoughts?
  • JLH64 

    Maybe you have data in non contiguous range i.e. you may have one or more blank columns in between.

    To select all the non contiguous data, select cell A1 and press Ctrl+Shift+End.

    • JLH64's avatar
      JLH64
      Copper Contributor
      Thanks - Ctrl+Shift+End selects every cell in the spreadsheet (A1 -> XFD 1048576). How can I select just the cells I know I have data in? I'm not sure if this is the reason why when I sort a column of numbers that not all cells are part of the sort.)
      • Subodh_Tiwari_sktneer's avatar
        Subodh_Tiwari_sktneer
        Silver Contributor

        JLH64 

        When you press Ctrl+End which cell gets selected?

        Ideally this should be the last cell used on the worksheet either for entering data, applying a formula or any kind of formatting to it.

        Whichever cell you get after pressing Ctrl+End, is it really the last cell used on that worksheet?

Resources