Freeze cells

  • Thread starter Thread starter darlene lassiter
  • Start date Start date
D

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????
 
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
 
Back
Top