excel2007 超链接 打开方式

根据您的描述，我理解为当您使用Office 2007 中的超级链接的时候，收到了“由于本机的限制,该操作已被取消”的错误信息。通过研究，引起这个错误的原因有很多种，您可以e799bee5baa6e59b9ee7ad94363先对下面的设置进行修改看看有没有帮助：

查看Word设置

1.打开Word 2007，然后点击office按钮--- Word Option 选项
2.点击校对标签，然后点击自动更正选项
3.点击自动套用格式标签
4.看看Internet及网络路径替换为超链接选项有没有勾选，若没有就勾选，有的话继续下面的修改：

查看IE设置

1.在IE中，点击工具选项，然后选择Internet选项
2.点击程序，然后选择重置Web设置

重要提示：请您提前备份好注册表，以防误操作导致严重后果。
如何备份注册表情参考：
http://support.microsoft.com/kb/322756/

查看注册表键值

1. 在开始运行中输入regedit， 打开注册表
2. 找到下面的路径： HKEY_CURRENT_USER\Software\Classes\.html

如果没有.html就新建一个，把默认的键值改为：htmlfile

3. 重新启动office然后看看问题还存不存在。

如果仍然存在 那么请尝试下列步骤，打开一个记事本，复制下列内容，然后另存为.reg文件，然后双击导入：

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.htm]
"PerceivedType"="text"
@="htmlfile"
"Content Type"="text/html"
[HKEY_CLASSES_ROOT\.htm\OpenWithList]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Excel.exe]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Excel.exe\shell]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Excel.exe\shell\edit]
@="&Open"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Excel.exe\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" /e"
"command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\
00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,\
24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,61,\
00,54,00,4f,00,35,00,20,00,2f,00,65,00,00,00,00,00
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Excel.exe\shell\edit\ddeexec]
@="[open(\"%1\")]"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Excel.exe\shell\edit\ddeexec\application]
@="Excel"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Excel.exe\shell\edit\ddeexec\topic]
@="system"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Excel]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Excel\shell]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Excel\shell\edit]
@="&Open"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Excel\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" /e"
"command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\
00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,\
24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,61,\
00,54,00,4f,00,35,00,20,00,2f,00,65,00,00,00,00,00
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Excel\shell\edit\ddeexec]
@="[open(\"%1\")]"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Excel\shell\edit\ddeexec\application]
@="Excel"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Excel\shell\edit\ddeexec\topic]
@="system"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Publisher]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Publisher\shell]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Publisher\shell\edit]
@="&Open"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Publisher\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\MSPUB.EXE\" %1"
"command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,50,00,75,00,62,\
00,50,00,72,00,69,00,6d,00,61,00,72,00,79,00,3e,00,74,00,57,00,7b,00,7e,00,\
24,00,34,00,51,00,5d,00,63,00,40,00,3f,00,46,00,40,00,36,00,6b,00,78,00,61,\
00,54,00,4f,00,35,00,20,00,25,00,31,00,00,00,00,00
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Word]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Word\shell]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Word\shell\edit]
@="&Open"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Word\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\WINWORD.EXE\" /n /dde"
"command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,57,00,4f,00,52,\
00,44,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,24,00,\
34,00,51,00,5d,00,63,00,40,00,35,00,64,00,31,00,60,00,2c,00,78,00,61,00,54,\
00,4f,00,35,00,20,00,2f,00,6e,00,20,00,2f,00,64,00,64,00,65,00,00,00,00,00
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Word\shell\edit\ddeexec]
@="[REM _DDE_Direct][FileOpen(\"%1\")]"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Word\shell\edit\ddeexec\Application]
@="WinWord"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\Microsoft Office Word\shell\edit\ddeexec\Topic]
@="System"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\MSPub.exe]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\MSPub.exe\shell]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\MSPub.exe\shell\edit]
@="&Open"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\MSPub.exe\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\MSPUB.EXE\" %1"
"command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,50,00,75,00,62,\
00,50,00,72,00,69,00,6d,00,61,00,72,00,79,00,3e,00,74,00,57,00,7b,00,7e,00,\
24,00,34,00,51,00,5d,00,63,00,40,00,3f,00,46,00,40,00,36,00,6b,00,78,00,61,\
00,54,00,4f,00,35,00,20,00,25,00,31,00,00,00,00,00
[HKEY_CLASSES_ROOT\.htm\OpenWithList\notepad.exe]
@=""
[HKEY_CLASSES_ROOT\.htm\OpenWithList\WinWord.exe]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\WinWord.exe\shell]
[HKEY_CLASSES_ROOT\.htm\OpenWithList\WinWord.exe\shell\edit]
@="&Open"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\WinWord.exe\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\WINWORD.EXE\" /n /dde"
"command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,57,00,4f,00,52,\
00,44,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,24,00,\
34,00,51,00,5d,00,63,00,40,00,35,00,64,00,31,00,60,00,2c,00,78,00,61,00,54,\
00,4f,00,35,00,20,00,2f,00,6e,00,20,00,2f,00,64,00,64,00,65,00,00,00,00,00
[HKEY_CLASSES_ROOT\.htm\OpenWithList\WinWord.exe\shell\edit\ddeexec]
@="[REM _DDE_Direct][FileOpen(\"%1\")]"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\WinWord.exe\shell\edit\ddeexec\Application]
@="WinWord"
[HKEY_CLASSES_ROOT\.htm\OpenWithList\WinWord.exe\shell\edit\ddeexec\Topic]
@="System"
[HKEY_CLASSES_ROOT\.htm\PersistentHandler]
@="{eec97550-47a9-11cf-b952-00aa0051fe20}"
[HKEY_CLASSES_ROOT\.html]
"PerceivedType"="text"
@="htmlfile"
"Content Type"="text/html"
[HKEY_CLASSES_ROOT\.html\PersistentHandler]
@="{eec97550-47a9-11cf-b952-00aa0051fe20}"
[HKEY_CLASSES_ROOT\htmlfile]
"AppUserModelID"="Microsoft.InternetExplorer.Default"
@="HTML Document"
"FriendlyTypeName"="@C:\\Windows\\System32\\ieframe.dll,-912"
[HKEY_CLASSES_ROOT\htmlfile\ScriptHostEncode]
@="{0CF774D0-F077-11D1-B1BC-00C04F86C324}"
[HKEY_CLASSES_ROOT\htmlfile\shell]
@="opennew"
[HKEY_CLASSES_ROOT\htmlfile\shell\Edit]
@="&Edit"
[HKEY_CLASSES_ROOT\htmlfile\shell\Edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\msohtmed.exe\" %1"
[HKEY_CLASSES_ROOT\htmlfile\shell\open]
@="Open in S&ame Window"
"MUIVerb"="@C:\\Windows\\System32\\ieframe.dll,-5732"
[HKEY_CLASSES_ROOT\htmlfile\shell\open\command]
@="\"C:\\Program Files\\Internet Explorer\\iexplore.exe\" -nohome"
[HKEY_CLASSES_ROOT\htmlfile\shell\open\ddeexec]
@="\"file://%1\",,-1,,,,,"
"NoActivateHandler"=""
[HKEY_CLASSES_ROOT\htmlfile\shell\open\ddeexec\Application]
@="IExplore"
[HKEY_CLASSES_ROOT\htmlfile\shell\open\ddeexec\Topic]
@="WWW_OpenURL"
[HKEY_CLASSES_ROOT\htmlfile\shell\opennew]
@="&Open"
"MUIVerb"="@C:\\Windows\\System32\\ieframe.dll,-5731"
[HKEY_CLASSES_ROOT\htmlfile\shell\opennew\command]
@="\"C:\\Program Files\\Internet Explorer\\iexplore.exe\" %1"
[HKEY_CLASSES_ROOT\htmlfile\shell\opennew\ddeexec]
@="\"%1\",,-1,0,,,,"
"NoActivateHandler"=""
[HKEY_CLASSES_ROOT\htmlfile\shell\opennew\ddeexec\Application]
@="IExplore"
[HKEY_CLASSES_ROOT\htmlfile\shell\opennew\ddeexec\IfExec]
@="*"
[HKEY_CLASSES_ROOT\htmlfile\shell\opennew\ddeexec\Topic]
@="WWW_OpenURLNewWindow"

CTRL+鼠标左键 是多选操作，不可以设置成超链接打开方式

EXCEL默认没有设置打开超链接的方式
如果是通过快捷键方法打开超链接，VBA是可以做到的。

我是这样操作的：

1. 先点菜单键（空格键右边第三个键）
   

2. 点两次上方向键，点回车

注：我是Excel2007，这样只用右手就可以完成了

这个确实十分不方便，尤其是一些邮箱地址，填充完之后就变成了超链接形式，特别百痛苦。
以上是共情度。

那研究过发现，excel对这个问题有计较：
对于存在超链接的单元版格，鼠标单击一次是打开超链接，但鼠标按住几秒即可选中这个单元格了~
将光标放在带超链接的单元格上方，会自动显示提示（2007以上版本）如下：
单击一次可跟踪超链接

单击并按权住不放可选择此单元格

祝好，新年快乐。