Paste Special Function
If you have two instances of Excel running with a workbook in each, you will
get the paste specialunicode, text etc. dialog.
Close one instance of Excel and open both workbooks in one instance.
If copying from a source other than Excel, unicode, text etc. dialog is all
you will get.
No way to change that.
Gord Dibben MS Excel MVP
On Tue, 30 Sep 2008 09:33:01 -0700, Steven D
wrote:
I often have to copy information to a new excel sheet and keep the column
length. When trying to use the Paste Special function I sometimes get a page
with paste as Unicode Text or Text, sometimes I get a few more choices (I
think one of them is picture) and sometimes I get (what I want) where I have
many choices of what/how I want to copy which includes a radio button for
columns (I think it also includes rows, formulas and other useful things).
Why do I get different things and what can I do to get the page with the
many radio buttons?
|