how do i freeze part of a formula?

February 21, 2011 at 05:37:45
Specs: Macintosh
i need one reference in a formula (it refers to a cell in another sheet) to remain the same while the rest of the formula changes appropriately when the cell is copied & pasted. How do i do this?

See More: how do i freeze part of a formula?

Report •


#1
February 21, 2011 at 05:40:58
If I understand your question correctly, you just need to use an absolute cell reference.

Report •

#2
February 21, 2011 at 05:53:38
Thanks ijack. That was it.

Thanks again.


Report •

Related Solutions


Ask Question