Hello everyone:

I am working on a spreadsheet where the values on one sheet in a workbook
are appear on a second sheet in the same workbook using the following formula:

=('Employee List'!A171)

The input sheet is called Employee List. I would like to "lock" the values
in this formula so that when I copy to another cell they do not change. I
know that when I do this it will look like this:

=('Employee List'!$A$171)

How do I copy this format to additional cells without manually entering the $