Forum Discussion
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?
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.)
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?
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.
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.
