How do you hold a cell constant when copying a formula?

[stevenlcohen]

I know this is simple but I seem to remember putting some symbol in front of the cell so it doesn't point to a different cell as you copy the formula. Thanks

[jeffreybrown]

Hello & Welcome to the Board,

Highlight the cell and toggle the F4 button

http://office.microsoft.com/en-us/ex...003064048.aspx

[davesexcel]

Try the Dollar sign
=$A$1

[stevenlcohen]

thanks so much...