| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula won't change correctly when dragged
In Excel 2003:
I have this formula: ='5West'!F33 and I want to drag it down to the cell below this one and have the column reference ("F") change but not the row reference ("33") so the new formula would be: ='5West'!G33. But instead it changed the number and not the letter. If I make the formula: ='5West'!F$33, then it drags the formula down as is and still doesn't change the letter. How can I make it change the letter? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace a number in a sentence every time it is dragged | Excel Worksheet Functions | |||
| Locking Clolumn Color So It Won't Get Dragged Away | Excel Discussion (Misc queries) | |||
| Formula not changing when Dragged!!!! | Excel Discussion (Misc queries) | |||
| How do I keep text viewing correctly as I change zoom % | Excel Discussion (Misc queries) | |||
| Indirect reference to another sheet that can be dragged | Excel Worksheet Functions | |||
Threaded Mode
