如果我係sheet1有一格(例A1)想係sheet2其中一格跟足
咁我就要係sheet2個格打=sheet1!A1
但係如果我想一次過唔想打咁多個得唔得架呢?
我想sheet1 A1 打橫到 Z1
去 sheet2 A1 打直到 A26
有咩野方法唔洗一格一格咁打呀?
唔通一定要
係sheet2 A1打=sheet!A1
A2打=sheet!B1
.
.
.
.
A26打=sheet!Z1
?
EXCEL既sheet問題~
2007-05-31 6:05 pm
回答 (2)
2007-06-02 1:34 am
✔ 最佳答案
sheet1 A1 打橫到 Z1Sheet2 A1(不一定是A1, 任何一格都可以)
輸入公式 =INDEX(Sheet1!$A$1:$Z$1,1,ROW(A1))
然後下拉
假設在Sheet2不是A1, 而是 B6開始輸入公式, 公式內的ROW(A1), 仍然是A1, 不要改成B6
無需任何空白欄作輔助
另一公式亦可以, 僅供參考:
=INDIRECT(“Sheet1!”&ADDRESS(1,ROW(A1)))
2007-05-31 6:17 pm
In A1 Type 0, and A2 type = A1 +1, copy and plaste down to row 26
In coloum B1 type below and copy and plaste down to row 26
=INDEX(sheet!$A$1:$Z$1,1,A1+1)
=index(database, row,coloum)
In coloum B1 type below and copy and plaste down to row 26
=INDEX(sheet!$A$1:$Z$1,1,A1+1)
=index(database, row,coloum)
參考: me
收錄日期: 2021-04-13 18:09:40
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070531000051KK00749