Excel: 'always choose same cell' symbol for use in formulae

G

Guest

cannot find the symbol that you place after a selected cell in a formulae so
that when you write the formulae and then drag so the formulae is set for a
number of cells, one cell with this special symbol is always the same i.e.
constant
 
G

Guest

Enter the cell address, then press <F4> to make it constant. If you press
<F4> again, the column is constant, and if yiou press this again, the row
number is constant. Else, type the address eg $A$1, $A1 or A$1
 

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

Return duplicate max values in same cell 2
A "relative" absolute cell reference? 6
calc in excel 2
Automatically input a symbol in a selected cell 2
Recalculation of formulae disabled 2
Excel : Hiding/Locking Formulae 6
Excel Number Formulae 6
Copying a formulae down a column that includes an INDIRECT 10

Top