The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Why does the auto fill in my excel fails to work

Why does the auto fill in my excel fails to work

Super Learner
0
Votes
1
Answer

Hello i am currently in the second sub topic of the course which is introduction to business analytics… i dont know if its my excel…but i am currently on the trend analysis path… from the tutorials the tutor\’s excel auto fill works perfectly well after he tried auto filling the values he gets from the  formular for revenue and cogs…but mine doesnt work… when i try dragging it horizontally or vertically it will give me the same values 

1 Answer

365 Team
0
Votes

Hi Mohamed, 
Autofilling has always confused me too. It’s a bit strange because it works with these ‘unwritten’ rules, so to say.
So, what the instructor is doing is he’s selecting several cells 1,2,3 and then dragging down. In this way, Excel understands this is a series and continues the series. If you don’t make the selection and you only drag one cell, then you’ll receive the same value.
Hope this helps!
Best,
Ned

It still gives the same problem sire… from the tutorial it works but am having problems with mine

×
Online Data Science Training
SAVE 60%