Constant in Excel Formula

C

Chele

I remember using the $ i think to keep a column constant when doing a
formula. What is it?
 
S

Sheeloo

Four choices
$A$1 : both column and row do not change while copying
$A1 : row changes while copying down, no change while copying across
A$1 : column changes while copying across, no change while copying down
A1 : both change while copying across or down
 
A

Ashish Mathur

That is exactly what it does - keeps the row or column constant depending
upon where it is inserted. If before the column, then the column is
constant. Please read up on absolute and relative references in Help menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula required 1
Formula constants? 2
drag a formula downa column keeping one value the same? 2
Dragging across columns: I want column constant, but row increment 6
What happened to setting up a constant using F4? 1
keeping same-row(or column) cell constant in a formula while drag- 1
Is there a way to set a cell value to be constant in formulas? 4
Mapping integers to strings 5

Top