Freeze cells

[darlene lassiter]

How do you freeze cells instead of the rows or columns.
When i am working a fuction and try to copy from aw date
formula it copys all of the cells I do not want it to
copy the top cells. You use to vbe able to freeze the
cells in Lotus can you freeze on cell in Excel????

 

[Peo Sjoblom]

Use absolute reference for the cells that you want to be fixed

=A2+B2

instead use

=$A$2+B2

when copied down it will increment B2 to B3 and so on but A2 will stay the
same