none
EXCEL 2003 儲存格內容的『超連結』無法複製 RRS feed

  • 一般討論

  • 問題

    A1 儲存格的內容為 YAHOO 並設定超連結為 http://www.yahoo.com.tw

    B1 儲存格的內容為 =A1

    我這樣操作的結果 B1 的內容只能夠看到 YAHOO 字串,卻沒有超連結。

    不知道該用什麼方法 來取得 儲存格A1內容的超連結。

    煩請大大指點!!謝謝
    • 已編輯 jiunc 2009年5月4日 上午 11:43
    • 已變更類型 璉璉Moderator 2010年6月12日 上午 03:46
    2009年4月24日 上午 11:56

所有回覆

  • 煩請指點,謝謝!!
    2009年5月4日 上午 11:44
  • 有個很好用的paste special,或許其實你ctrl+c  ctrl+v不就行啦?
     公式可以參考:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
    =HYPERLINK("http://www.yahoo.com.tw","YAHOO")


    HSO | support.microsoft.com
    • 已編輯 Hourin 2009年5月6日 上午 08:56
    2009年5月5日 下午 02:50