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's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback