Hi,

Tap F4 to cycle through the referencing options

Mike

"R" wrote:

How can I automatically add the $ in a formula when I click on the chosen
cell? Is there a key that I can hold down to do this?