How To Drag and Autofill Months In Excel
In this intermediate Excel tutorial, you'll learn how to use the fill handle to autofill the Month's name in excel. Suppose We write January or Jan in any cell of our worksheet, and when we drag the fill handle, it should fill the Month's name sequentially, like January, February etc.
Now let's explain a bit about the fill handle. When working in Excel, the active cell has a Fill Handle. A black square at its lower right corner. When you hover your mouse to the Fill Handle, the mouse pointer changes to a black plus sign. You can drag this Fill Handle, or double-click it, to activate the AutoFill feature in Excel.
Before starting, you must understand how the fill handle works. If you write "A" on any cell and then drag that cell using the fill handle, the next cell should be filled with the Alphabet "B." In the same way, if you write "Sat," the next cell should be "Sun." Here we will do the same thing but with the Month's name. You write any month's name on any cell, and when you drag using the fill handle, the next cell should be filled with the next Month's name.
Here is how you can autofill the Month's name sequentially in excel.
Step 1: Write January to December on your worksheet manually. (This is one time. Once you are done, you'll never need to repeat this step.)
Step 2: Click on "File"
Step 3: Now click on "Options." Sometimes it's inside the "More" section.
Step 4: Click on "Advanced" and scroll down until you find the "General" section.
Step 5: You'll find "Create list for use in sorts and fill sequence." Click on the "Edit Custom Lists" button right beside this.
Step 6: Now select the data range where you have your Month's list and click on "Import."
Step 7: Click "Add" and then click "Ok."
Done! From now on, if you use the fill handle of the autofill feature, you'll be able to autofill from January to December sequentially.
Thanks for watching.
#autofill #monthsname #excel
----------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Website: https://msexceltutorial.com/
Смотрите видео How To Drag and Autofill Months In Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel 10 tutorial 04 Июль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 25,920 раз и оно понравилось 156 людям.