It used to be you could highlight a column, do a Copy and then, when you
selected paste, you were presented the opportunity to Transpose. I am not
offered the opportunity to Transpose. What gives?
It used to be you could highlight a column, do a Copy and then, when you
selected paste, you were presented the opportunity to Transpose. I am not
offered the opportunity to Transpose. What gives?
You need to select Paste Special not just Paste, then you will see the
option to Transpose
--
Regards
Roger Govier
"LordByron" <[email protected]> wrote in message
news:[email protected]...
> It used to be you could highlight a column, do a Copy and then, when you
> selected paste, you were presented the opportunity to Transpose. I am not
> offered the opportunity to Transpose. What gives?
The problem was that I was doing a Copy using HTML instead of text. HTML
doesn't give one the ability to Transpose but Text does. Thanks.
"Roger Govier" wrote:
> You need to select Paste Special not just Paste, then you will see the
> option to Transpose
>
> --
> Regards
> Roger Govier
> "LordByron" <[email protected]> wrote in message
> news:[email protected]...
> > It used to be you could highlight a column, do a Copy and then, when you
> > selected paste, you were presented the opportunity to Transpose. I am not
> > offered the opportunity to Transpose. What gives?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks