I have a column of cells, all of which I want to equal the value in another cell. I highlight the cell and type = and then do that again below, and then I highlight the cells and drag down but the column of cells equals a parallel column of values. I want it to fix to one cell. Does this make sense? I'm sure it's easy but I cannot figure it out.
If the cell you want to reference is A3, make your formula:
The dollar signs make the cell reference absolute, so they won't be adjusted relative to where you paste.