But even an absolute reference will change if the location
to which it refers to is changed by inserting or deleting rows, columns,
or cells. Just wanted to mention better how it is "locked".
Like the others said, applies to fill handle and copying and pasting.
Anything within quotes will not change when using the fill handle,
but will also not change if inserting or deleting rows, columns.
I think you already have the fill handle usage but just in case
and there is a lot more on the page besides the fill handle
http://www.mvps.org/dmcritchie/excel/filhand.htm
like use of the mouse.