I see that there was a bug request closed for this but no explanation was given other than "that's the way it is". It is something that excel supports and it is a lot easier than copying all of the data into a massive rectangle.
(In reply to austn3 from comment #0)
> ...It is something that excel supports
> and it is a lot easier than copying all of the data into a massive rectangle.
It sounds plausible as an enhancement, so this will live in NEW until someone picks it up to work on it or decides to reclassify it
Status -> NEW