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 ...

Microsoft Excel has four cell modes—Ready, Enter, Edit, and Point. Having the correct cell mode activated is crucial for effective data entry management, formula creation, and cell modification, and ...