Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How NOT to extend formula/refrence to a cell
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 |
#2
|
|||
|
|||
You could use:
=sheet1!$c$2 And drag down. Or you could just use a formula that points at that first formula: If you have =Sheet1!c2 in A1 then just use =$a$1 Then you only have one formula that points back to that other sheet--if/when you want to change it. wrote: 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 -- Dave Peterson |
#3
|
|||
|
|||
it worked .Thank you so much ,Dave
Dave Peterson wrote: You could use: =sheet1!$c$2 And drag down. Or you could just use a formula that points at that first formula: If you have =Sheet1!c2 in A1 then just use =$a$1 Then you only have one formula that points back to that other sheet--if/when you want to change it. wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions |