The choices you get depend on what you have copied.

Usually if you copy from an Excel sheet you get all the choices. If you copy
outside Excel then you get choices like 'paste as unicode', 'paste as
HTML',... etc.

"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?
--
Steven D