Dragging formulas down column endlessly through a sheet

[pamtupac]

Hi all,

I'm having an issue with a worksheet. I created multiple formulas in different columns but i'm having issues getting it to auto copy to the next cell. i noticed that if you copy and paste info into cells that feed the formula it won't copy the formula down. sometimes through the column the formula needs to be erased and a value needs to be places. ex. i set up an automatic due date based on a a specific product but the due date might need to be sooner due to urgency so the user will simply select the cell they need to change and write the new date. i really want to avoid having to pull the formulas down with the drag handle as its already causing so many issues. unfortunately the users of the excel are not very tech savvy. if someone can help me, my worksheet is set to calculate automatically so i'm not sure what's going on. i've never noticed this issue before but then again it's usually me using my own sheets or it populates from something else.

Thanks

 

[mole999]

do you have hidden or filtered rows ?

 

[pamtupac]

i have filters enabled but nothing is filtered. no hidden row ether. i tried using ctrl + shift + down to select the entire column until the very end and then control + d to copy (lol bad idea) but it made my workbook weigh almost 40mb from its original 170kb, i need it to weigh around 3mb max as more data has to be inputted daily and we use it in box, a cloud service, to allow everyone in the team to see it and edit it live.