copying cells without changing reference

L

lsu-i-like

on worksheet 1, i want to have a column of cells that do the following:
2D = 2A + 1A
3D = 3A + 1A
4D = 4A + 1A

i want one reference to change and one reference to stay the same. i
that possible, and if so, how?

i just figure it out, by using the indirect function again...

2d=2a+indirect("1a")
then just copy that cell.
wow, i love indirect
 
G

Guest

hi,
Absolute reference uses Dollar signs ($).
$A$1 will stay the same no matter where you paste it
$A1 the collumn will not change but the row will
A$1 The Row will not change but the column will
A1 both row and column with change.
-----Original Message-----
 

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

Top