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?