Hi all,

First, I have to admit I'm a complete moron. I just found out about using
the $ symbol in a cell to set the cell location when copy/pasting. Brilliant
idea, wish I'd figured it out sooner.

My problem is, I can't find any information on this. Probably because my
search terms aren't appropriate. I'm having a complete brain fart here.

So I'm hoping someone can tell me what this is called. Also, is there a way
to set the cell value from 'Sheet1'!A1 to 'Sheet1'!$A$1? A function key? A
co-worker says they saw someone do it, but can't remember what they used. I
have a couple of sheets I want to apply this to, and I don't want to retype
every value.

Any help is appreciated.

Jay