Microsoft Excel果個$有咩用??

假設 cell A2 內是用公式 (=A1) , COPY A2的 公式到B2時, 公或會變成 (=B1)
當 cell A2 內是用公式 (=$A1) , COPY A2的 公式到B2時, 公或會keep住是 (=A1)
$ 呢個符號係用黎固定左公式你 refer 番 A 呢個位置.

2007-01-18 19:30:05 補充：
打漏.... 第二行應該係 keep住是 (=$A1), 即顯示番 A1的內容.

References beginning with a dollar sign ($) tell Excel how to find cells based on their exact location in the worksheet. When a formula containing an absolute reference is pasted in new location, it still looks back at the location of the original cell. In the previous example, if the worksheet used absolute references, the formula would read "$B$2+$B$3+$B$4" Absolute references are similar to giving absolute directions, such as "it is located on the southeast corner of Dunn and Kirkwood".

Cell reference Meaning

$B$15 Both column and row references remain the same when you copy this cell reference because they are absolute

B$15 The column reference changes when you copy this cell reference to another column because it is relative. The row reference does not change because it is absolute.

$B15 The row reference changes when you copy this cell reference to another row because it is relative. The column reference does not change because it is absolute

B15 Both column and row references are relative. When copied to another row and column, both the row and column in the cell reference are adjusted to reflect the new location.