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