Forum Discussion

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?

excel

Subodh_Tiwari_sktneer

Silver Contributor

Oct 01, 2019

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

Copper Contributor

Oct 01, 2019

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
Silver Contributor
Oct 01, 2019
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?
- JLH64
  Copper Contributor
  Oct 01, 2019
  Subodh_Tiwari_sktneer
  
  When I press Ctrl+End, the last cell selected is Column CD, Row 296. In reality, the last cell in use is Column AY, Row 226.
  - JLH64
    Copper Contributor
    Oct 01, 2019
    When I press Ctrl + A, Columns A thru D, thru Row 226 are selected.
    
    Column C contains numbers. And, even though Column C is selected, I'm not able to sort the column sequentially and a few numbers don't even appear in the selection list for that column.