Filling in Formulas

**datkins** · 06-17-2009, 05:26 PM

Hi all,
I've been an avid excel user for years, and I am totally stumped!
I am trying to simply fill in formulas, for example:
cell C1 =A1+B1

everything calculates fine
I use the fill handle to drag the formula down the rest of my column, in the cells, the formulas all change appropriately =A2+B2, but it keeps filling in the value from C1, the entire column!!!!

argh!!

PLEASE HELP!!!

**oldchippy** · 06-17-2009, 06:44 PM

Hi,

Welcome to the forum, it would be better if you post a workbook then we can see for ourselves how we can help?

**kellyfspringer** · 06-17-2009, 07:50 PM

I know exactly what you are talking about, and it has happened to me, too. I finally figured out what it was. Go to the Tools menu, and choose "Options", then go to the "Calculation" tab. Make sure that the check box is chosen for "Automatic" rather than "Manual". And you should be good.
Even if it is on manual, you can press F9 at any time to have it update the formulas.

**datkins** · 06-17-2009, 08:46 PM

Thank YOU Kelly!!! This has been driving me nuts all day! Fixed it perfectly. Now to just figure out how settings like that get changed without my doing!

**kellyfspringer** · 06-17-2009, 09:15 PM

oh glad to help! I have been told that when you are working from any excel spreadsheet (or even a word document actually), the settings from the original author will be set to their preferences.

**goran69** · 10-16-2014, 04:34 AM

I know about old threads but thank you so much bcs this was driving me crazy. Thank you

**abhilashxhr** · 03-08-2015, 12:04 PM

HI Kelly,

I've been struggling all day, your suggestion worked like a magic. This is the first time i'm visiting this forum and i registered only to thank you.

Great work !