View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default copy cells which are horizontal to verticle

Ivano

You can add the toolbar button (Right click on any toolbar and select
customize... and look under the edit category and when you find it, just
drag and drop it on a toolbar)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Ivano" wrote in message
...
Thanks that worked.
Is there a short cut key for paste special?

"nuver" wrote:


You could copy the selection and then use paste special and check the
transpose check box on the bottom right corner of the dialog box.

Ed


--
nuver
------------------------------------------------------------------------
nuver's Profile:
http://www.excelforum.com/member.php...o&userid=10036
View this thread:
http://www.excelforum.com/showthread...hreadid=486471