I've seen this problem reported for at least 7 years now, and Microsoft still hasn't fixed it (I'm running "Microsoft 365" and just updated recently).
1. Open the attached worksheet.
2. Select ANY cell with data in it.
3. Click Ctrl-A to "Select All".
Result: Excel will only select some of the data.
This feature is called "Select ALL". It's really frustrating that it doesn't do that.
I realize the attached file is trivial, because it's easy to see that Ctrl-A isn't working and select the rest by hand before sorting or copying. But I have this problem working on files with 100,000+ lines and 100+ columns. In those cases, there's no visual clue that Ctrl-A isn't working properly before proceeding to make bad changes to my worksheet.
I also realize that blank cells are the problem. But Excel should be able to handle data with empty fields.
Clay
Bookmarks