You don't get it.

This argument is futile because you are not going to get it.

The future will prove you wrong on this point. When you see that Excel WILL
have this functionality built into it, you will learn that you did not get
this point.

Until then, bitch and moan all you want, because you don't understand enough
to get it.

"Harlan Grove" wrote:

stan-the-man wrote...
So then what you are saying is that you are so small-minded that you don't
look for enhancement-opportunities. You only look for opportunities to show
how much of a smart aleck you can be: opinionated and derogatory.

No, I'm saying many features requested by less experienced users are
unnecessary because the functionality already exists, though often it
requires formulas.

If everyone got to add a feature to Excel, it'd never be able to run.
There's a trade-off between more features and huge-and-slow. To me,
Excel is already huge and slow, so adding ever more unnecessary feature
only worsens the problem. Your suggestion would make Excel worse for
me, so I react acordingly. If you can't handle that, wait a few years
until you grow up, then come back to the newsgroups.

If it is not showing up in the Excel 2007 beta, it is because they haven't
thought about it yet. Look for it in future versions. I am a visionary.
You are opinionated. The future will prove this statement to be true. Watch
and learn.

You just don't know how to use the alternatives. Nothing visionary
unless you like the view ostriches have when they bury their heads.

I do agree that I'm opinionated. You're not?

This 'feature' has been suggested every couple of months or so in the
Excel newsgroups for that last decade at least. It's likely some of
those people have made the suggestion to Microsoft. It's not in Excel
2007 because Microsoft programmers can figure out for themselves that
it's not widely requested. It can be done using formulas. It can be
done by adding an adjacent row or column filled with sequential
numbers, sorting, and removing the added row or column. It can be done
by macros. Why add it to Paste Special? As for Paste Special
Transpose, it could have been added for Lotus 123 compatibility way
back when Excel had less market share than 123.

I've watched Excel's progress since the first Mac version. I have no
doubt your pet feature won't make it into Excel during the remainder of
my working life (a few more decades). After that I won't much care. For
the next 3 versions at least, it'll be you who has the opportunity to
learn, but likely you'll miss the opportunity yet again.