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

When editing a formula in a dialog box in Microsoft Excel, you might go to use the Arrow keys to move the blinking cursor to a different position. However, frustratingly and confusingly, doing this ...

Every time Dave publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from Business ...