Solution: Excel drag to “fill” not working – value is copied, formula ignored

[nataliebaddour]

You just saved me from a meltdown, much appreciated

[travislvanslooten]

PERFECT. Spent about 30 minutes racking my brains over what was going on with my spreadsheet because it wasn't calculating correctly. Your video solved my problem in minutes. THANK YOU!!

[SatisfiedOnion]

Very seldom (never?) do I run across a strange issue and actually find the correct solution on the first link I click. Baffled was an understatement. I could not figure out for the life of me what was going on! Thank you for this video.

[tehnikbeograd]

Oh man, you are my hero, i have been busting my ass for 2 days trying to solve the problem. Extremely helpful video!

[gordonmolapo]

Hi, thank you so much for the demonstration. However, the two options do not work and I was hoping there's a third option

[TicklePickleLover]

i spent 3 days reading blogs and watching how to videos, yours is the only one that mentioned the calculator function. Thank

[commiebobo]

This didn't change anything for me, still getting all the same results. Everything is set as you specified. Any advice?

[MsYongbang]

OH MY GOD! THIS IS EXACTLY THE ANSWER THAT I AM LOOKING FOR RIGHT NOW. YOU SOLVED MY PROBLEM, THANK YOU SO MUCH!

[hullo]

Hey Nate, thanks for the video. It's not working for me, but maybe you can help. I just want the 'fill series' to work without me manually selecting it. I want to type the number '1' in a cell, drag the handle down, and have it continue '2, 3, 4' etc. Right now it's just copying '1' a million times. I know that I could change the autofill options, but every time? No thanks.

[bradleyyost]

Honestly, I thought I was losing my mind and could not figure out why the formula was copying but the value in the cell was remaining the same. Thank you for the video!

[climbon]

Thank you!!!! I actually found this video on my work machine, and had to come all the way here via my phone just to comment my appreciation!

So much wasted googling and doc reading leading nowhere. You saved me from pounding my head more 😂

[mariaod]

Thank you! Thank you! You rock! I upgraded to Excel version to 2016 and thought it was that! I spent a better part of 2 hours reformatting my data, cleaned, trimmed, etc., trying to figure this out! OMG!!!!

[bryanlopez]

Wow, I wish I came to youtube first. It would've saved me a 5 hour headache. Thanks Nate!

[andytownman]

Thank you so much. I had changed this setting to improve Excel performance (a tip from another site) but didn't realize it would have this unintended effect.

[laurencoopermarketeer]

Thanks a million for this tip - i was nearly going nuts trying to figure out why the formulas weren't' calculating properly.

[blancitakiwanga]

You saved my life today!! Been trying for hours without a success. Until I found your video. Thank you so much❤

[jackrsouth]

This fixed a problem I had been stuck on for a while, thank you so much!

[sherryssweetsensationz]

Sir I spent days trying to fix this. THANK YOU for sharing this unbelievable quick fix. GOD BLESS YOU.

[ngourab]

No amount of "THANKS" is enough for this. Subscribing to your channel.

[donnagustavson]

Brilliant - just brilliant!!!! Agonizing and frustrated with my budget for 3 1 minute and the crazy making error on my part has been rectified!!! Thank you.