Excel의 Absolute Reference

질문 : Cell의 formula를 Copy & Paste 할 때 특정 cell에 대한 reference가 변하지 않도록 하는 법?

답 : 예를 들어 A1을 Absolute reference로 쓰려면 $A$1이라고 쓰면 된다.
Row만 Absolute reference로 하려면 A$1로,
Column만 Absolute reference로 하려면 $A1로 하면 됨.

Shortcut : 간편히 핫키로 하려면 edit mode 에서 Command + T 를 치면 됨.
Command + T (edit mode) : Toggle Anchoring ($ in cell ref)

응용 예 :
Excel에서 Multiplication Table 만드는 법?

인용 : If part of an Excel formula references one fixed cell, you'll need to make some adjustments to that formula before copying and pasting it to other cells.

You need to indicate to Excel that the reference to C1 in the formula is Absolute. Do this by inserting a dollar sign before the C and before the 1 in the formula. The formula in F4 would change to =ROUND((D4*E4)*$C$1,2). As you copy this formula down to other rows in your dataset, the portion that refers to $C$1 will continue to point at $C$1

레퍼런스 : Microsoft Excel: Copy a Formula While Keeping One Reference Fixed