10-01-2019 09:08 AM
10-01-2019 09:19 AM
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.
10-01-2019 09:30 AM
10-01-2019 10:00 AM - edited 10-01-2019 10:01 AM
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?
10-01-2019 10:50 AM
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.
10-01-2019 10:59 AM
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.
10-01-2019 11:05 AM
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.