ExcelBanter - what symbol should i put in the formula to make a cell constant?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - what symbol should i put in the formula to make a cell constant? (https://www.excelbanter.com/excel-discussion-misc-queries/99307-what-symbol-should-i-put-formula-make-cell-constant.html)

emreak81

what symbol should i put in the formula to make a cell constant?

Niek Otten

what symbol should i put in the formula to make a cell constant?

If you mean you don't want the cell reference to change when you copy/paste:

$A$1

Or explain what you mean

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"emreak81" wrote in message ...
|

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