Excel ,sheet name

2007-12-15 12:00 am
想把cell A1 設定為sheet name, 請問有沒有formula 做到?

thank you

回答 (3)

2007-12-16 7:17 am
✔ 最佳答案
A1 輸入
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)
2007-12-20 1:58 am
You just click twice an you can change the name same as a1, of course, you must write it correctly.
2007-12-15 12:33 am
唔需要formula,你直接係 Name Box度改名就可以啦!

唔明白再問我啦!
參考: 自己


收錄日期: 2021-04-13 14:44:10
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071214000051KK01677

檢視 Wayback Machine 備份