MICROSOFT OFFICE TUTOR: Never type an Excel absolute reference again

Absolute references keep an Excel cell reference from changing when you copy and paste it into another cell. Although you can manually create an absolute reference by typing a dollar sign before any Excel reference, we’ll show you a faster option.