Constants or How not to increase pointer cell automatically

C

Charlie

Nick,

You need the make the cell reference absolute. For example
=$C$3 will make C3, when copied, appear as C3 in each
copied cell. To use the absolute in a formula either type
the $ manually or press the F4 key while typing the
formula.

Charlie O'Neill
 

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

Cells not updated automatically 3
Referencing cells in consecutive rows 2
Need formula to automatically populate Sheet 2 cells with same content as Sheet 1 1
Mapping integers to strings 6
trouble with (complicated) vlookup searching another workbook 2
Overwriting a cell with a formula without deleting the formula 1
Retaining cell reference in destination, when sorting source file 3
How to fill cell references from several worksheets in one? 2

Top