Paste as Hyperlink option not present

[Bodrulm]

Hello all,

I don't seem to have the 'Paste as Hyperlink' option under Home>Clipboard> drop down on Paste. The nearest is Past Link which is totally different.

This was present in Excel 2007 but I no longer have it in Excel 2010. The option I'm after is demonstrated in this very short video: http://www.youtube.com/watch?v=TyVq-CDCMLU&feature=player_embedded#

Any idea where it went?

<table border="0" cellpadding="0" cellspacing="0" width="64"><tr height="20"><td style="height:15.0pt;width:48pt" height="20" width="64">
</td></tr></table>

 

[Jerry Sullivan]

This is an old thread, but I came accross it while trying to find an answer to this question.

In Excel 2010, the 'Paste as Hyperlink' command is no longer part of the default commands in the Home Tab > Clipboard Group.

It can be added to the be added to the QAT or Ribbon from the commands listed as "Commands not in Ribbon".

Right-Click on the QAT > Customize Quick Access Toolbar... >
Choose commands from... >
"Commands Not in Ribbon"
select 'Paste as Hyperlink' from the list of commands.