How to drag numbers in excel without increasing
How to solve "drag to fill not working" or enable fill handle and cell drag & drop in excel
Timecodes:
Hello Everyone.
Welcome to excel 10 Tutorial.
In this quick tutorial i'm going to Solve a problem.
Ok?
Now i'm going to solve if your auto-fill handle or drag to fill isn't working how you can
solve it.
Ok.
[Music] Now take a look at here we have 1 and if i
want to drag this, there is no auto-fill handle here.
Ok?
You can see that the cursor isn't changing.
And i want to drag and then the number should be auto-filled or if i write any formula here.
This one. and if i want to copy the formula to all the column here but i can't do that
because of the auto-fill handle isn't working.
Now there could be several issues because of this problem.
No. 1 if you are working with formulas and its not working there is a chance that you
have tolve it from here.
Click on formulas and click on Calculation Options and if its not automatic you gotta
make it automatic.
Sometime it is manual so then the auto-fill handle might not work so you'll have to select
it to automatic.
In my case its already automatic but i can't access the auto-fill handle here.
Ok?
I can't drag any formulas or any numbers so how can i solve this.
There is another place where you can turn on auto-fill handle or turn off auto-fill
handle.
Ok?
So, click on the file option.
Click on options.
Click on advanced and you can see here enable fill handle and cell drag & drop.
You can see.
This is the place where you can enable and disable fill handle and cell drag and drop.
So.
Click here, Click ok.
Now this is our formula you can see the cursor has turned to drag & drop.
So if i drag it the formula works so take a look at here.
If i press CTRl and drag & Drop the serial number has autofill.
This is what i wanted to show you.
This is how you can enable auto-fill and drag & drop in Microsoft excel.
hope you understand.
Hope your problem is solved.
keep learning.
Thanks for watching.
Don't forget to subscribe.
Stay in your home.
Be safe.
Thank you
Related queries:
how do you drag numbers in excel without increasing
how to drag numbers in excel increasing
how to drag in excel without changing numbers
how to get excel to drag numbers
