Is there a way to hold down shift/ctrl, etc to make a cell reference an absolute reference when entering a formula instead of having to go back and enter $?

If you're using Microsoft Excel on a Windows PC and enjoy using keyboard shortcuts to improve your productivity, you should definitely learn the many ways in which F4 can save you lots of time. To ...

An address or pointer that changes when the target item is moved or the relationship to it has changed. For example, in a spreadsheet, a cell with a relative reference changes its formula when copied ...