Good job on this valuable shortcut. It may also have been valuable to transition into creating custom lists, as Excel does a great of auto-filling such things as lists of employees, a list of counties, area codes, inventory ID numbers, etc,
Hi... I am new to excel, but I have some columns that will populate some with the same number and others to automatically go in sequence. how do I make them all the same (I want to keep the same number)
Thank you for providing useful tips for using Excel. I’m looking for a solution for my Auto fill handle. The problem is that the solid black cross doesn’t easily appear when I hover over the green box. It takes slow and precise pointing to get it to appear. If you know the solution for this I would greatly appreciated. Thanks again for your Excel tutorials; you’ve been lots of help already.
I'm sorry but this is not correct. Days and Months are not logicaly incremented because they are time related, but because these are predefined text series that Excel knows. It's just plain text, and you can create your own series. You can find the predefined series well hidden in Excel Options > Advanced Options > General (almost at the bottom) > Modify Personalized Lists (not sure of the exact wording in English, sorry). You'll see that series for days in the week and months are there, with variation for abbreviated forms. If you want to create your own list that will be available to all new documents you create on that computer, that's the place. If you want to have the list of the American States at hand to autofill, for instance, just do it there. I also use the example of the radiophony alphabet (Alpha, Bravo, Charlie, Delta, ... , Yankee, Zulu) or zodiac signs, why not? Also, if you want numeric series (whole numbers) to be incremented by one unit, just use SHIFT while click and dragging from the first entry. Using the autofill handle to the left or up will decrement the values. If you want to decrement from top to bottom or left to right, you need to start with a pattern, though (10, 9, ... and 2 is enough). Excel isn't that smart: you can not start with the first primes and hope that Excel will autofill the next ones, but if you know the way to make a Fibonacci suite, you can do it with autofill. Fun to show to students.
What a gifted teacher! Explains things so well and clearly.
Good job on this valuable shortcut. It may also have been valuable to transition into creating custom lists, as Excel does a great of auto-filling such things as lists of employees, a list of counties, area codes, inventory ID numbers, etc,
Thanks for the suggestion. I’ve already recorded a follow up video that shows exactly that. It might take a little while before I post it though.
Excellent explanation thank you
You are super great in your teaching skills I must confess
Thank you. very helpful.
Thank you so much. I wish there was something like the double click for horizontal auto fill.
Yes. I asked this question on a similar video of his.
I'm so thankful I found your videos!
Thanks a bunch!!!
Yeah.. thank you
Hi... I am new to excel, but I have some columns that will populate some with the same number and others to automatically go in sequence. how do I make them all the same (I want to keep the same number)
Thank you so much!!!!! amazing teacher
Your tutorials are the best
Thank you. This was helpful.
Thanks alot Boss, it has been very informative
this is so helpful.plz continue posting interesting videos ,sir.god bless you
Tysm!!
Thank you for providing useful tips for using Excel. I’m looking for a solution for my Auto fill handle. The problem is that the solid black cross doesn’t easily appear when I hover over the green box. It takes slow and precise pointing to get it to appear. If you know the solution for this I would greatly appreciated. Thanks again for your Excel tutorials; you’ve been lots of help already.
thank u!
How would things differ if I were working on an iPad using the Excel app instead of working on my computer ?
Simply awesome👌👌
How about date? Please do tutorial. Thank you for your video!
useful. Thank you.
1. How to resolve when Excel doesn't Figure it out that we want month-to-month,etc.?
2. Autofill options little icon doesn't show, how to fix it?
👍👍👍👍👍
Who is still stuck at "that innocent looking square" 😄
u called it DEPTH ??. sorry whereas the SERIES feature pal
I'm sorry but this is not correct. Days and Months are not logicaly incremented because they are time related, but because these are predefined text series that Excel knows. It's just plain text, and you can create your own series. You can find the predefined series well hidden in Excel Options > Advanced Options > General (almost at the bottom) > Modify Personalized Lists (not sure of the exact wording in English, sorry). You'll see that series for days in the week and months are there, with variation for abbreviated forms. If you want to create your own list that will be available to all new documents you create on that computer, that's the place. If you want to have the list of the American States at hand to autofill, for instance, just do it there. I also use the example of the radiophony alphabet (Alpha, Bravo, Charlie, Delta, ... , Yankee, Zulu) or zodiac signs, why not? Also, if you want numeric series (whole numbers) to be incremented by one unit, just use SHIFT while click and dragging from the first entry. Using the autofill handle to the left or up will decrement the values. If you want to decrement from top to bottom or left to right, you need to start with a pattern, though (10, 9, ... and 2 is enough). Excel isn't that smart: you can not start with the first primes and hope that Excel will autofill the next ones, but if you know the way to make a Fibonacci suite, you can do it with autofill. Fun to show to students.
Thanks for this info. I want to make a video about it. Thanks for watching and commenting!
Very helpful, thank you
Thank you. This was helpful.