Hi
One of the cells( of sheet2) of my excel has formula as =Sheet1!C2
I want the next (say 30 ) cells to have the same formula =Sheet1!C2.
I dont want excel to automatically change the refrence to C3,C4,C5.....

Turning off toolsoptionseditextend data range formats and formula
Doesnt help. Can someone help me out.
Thanks in advance...Pankaj