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

Essential Shortcuts Aside from the well-known Excel keyboard shortcuts, these are the ones I use the most often and save me the most time.

Looking for a faster way to work with your spreadsheets? Check out these Excel keyboard shortcuts you should know for quick actions and easy navigation.

To create a similar shortcut-reference list for Excel, go to Microsoft's compilation of Excel shortcut and function keys. Follow the instructions above to select, copy, and paste the shortcuts ...