Quick question, I'm trying to have excel fill a formula across a row of cells horizontally and when I do it changes the columns (letters) of the formula but what I want it to do is change the rows (numbers). I know it would do this if I was filling it down vertically, but the project i'm working on it has to be orginized horizontally. I put a $ in front of the letter so it doesn't change the letter but it still won't change the number in the formula. If anyone can help it would be greatly appreciated cause changing all these cells by hand would be a bitch.