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 $?

Microsoft Excel 100 Most Useful Shortcut Keys While operating Excel, you will get many keyboard shortcuts that will help in increasing efficiency and productivity.

Shortcut keys can allow you to work more quickly and efficiently in the Microsoft Excel program, allowing you to type quick keyboard combinations to perform tasks.

Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work.

Learn how to improve your productivity by creating custom Excel shortcuts to improve efficiency when using spreadsheets in Microsoft's ...

Unfortunately, you won’t find the “edit this cell” command listed in Excel’s keyboard customization section, so there’s no apparent way to change the shortcut.

To copy the same formula to other cells in Excel is easy, and you can use keyboard shortcuts, AutoFill or Copy and Paste command.

Q. Sometimes an Excel convenience can become a handicap. For example, if you move a formula to a new location, Excel will automatically change the formula to reflect the new location. But that ...