ExcelBanter - Using the $

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using the $ (https://www.excelbanter.com/excel-worksheet-functions/243944-using-%24.html)

Using the $

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?

Mike H

Using the $

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?

Eduardo

Using the $

Hi,
use F4

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

All times are GMT +1. The time now is 04:53 AM.