| 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 |
| 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 | |||
Threaded Mode
