Share via

於Excel 2007如何為圖片加入公式

Anonymous
2013-06-02T05:24:03+00:00

於其他Excel版本，於其中一個工作表設立一系列圖片，設定OFFSET，MATCH公式後，將圖片複製到其他工作表內，選取該圖片，於公式列上可輸入=picture1 連結至原始系列圖片，圖片可隨着選取而改變。

我於Excel2007建立同樣工作表，當選取圖片後，公式列內卻不能輸入任何資料，如果Excel2007沒有為圖片加入公式功能，請問應如何為圖片加入公式?

謝謝！

Alisteir

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2013-06-02T05:25:26+00:00

Please select your language clicking on the Globe picture at the bottom left hand side corner to post your question in the language of your choice. The forum you posted in is for English only. If you do not find the desired language, support options for additional international locations can be found by following the link below:

http://support.microsoft.com/common/international.aspx

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest