有A1 A2 A3
如何將A1 A2 A3 同時分別乘B1的數字
A1 乘 B1
A2 乘 B1
A3 乘 B1
如何快速做到?
excel 乘問題?
2016-01-19 12:23 pm
回答 (1)
2016-01-19 12:58 pm
把想要固定的欄位加上$的符號，像是=A1*B$1
再往下複製格式的時候，欄位就會固定住了https://s.yimg.com/hd/answers/i/79892fb2ac1f479bb278ff53ffef0c23_C.jpeg?a=answers&mr=0&x=1453215449&s=d88436b57fb1a460085a3556d380b94d
https://s.yimg.com/hd/answers/i/da8a6111d45746d9afd219854dfe823f_C.jpeg?a=answers&mr=0&x=1453215466&s=79a4ec009ddba4c4d38b8874a21197d5
再往下複製格式的時候，欄位就會固定住了https://s.yimg.com/hd/answers/i/79892fb2ac1f479bb278ff53ffef0c23_C.jpeg?a=answers&mr=0&x=1453215449&s=d88436b57fb1a460085a3556d380b94d
https://s.yimg.com/hd/answers/i/da8a6111d45746d9afd219854dfe823f_C.jpeg?a=answers&mr=0&x=1453215466&s=79a4ec009ddba4c4d38b8874a21197d5
收錄日期: 2021-05-04 02:11:14
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20160119042300AAmn8Sm