spandanRajput: difference betweenlist auto fill and auto fill features of Ms excel 2007??
Answers
Answer:
give you the best experience and service. By accessing this site, you consent to the use of cookies. For more information, refer to Ablebits Privacy Policy
Got it!
Ablebits.com Blog Excel Tips and How-to
Search
How to use AutoFill in Excel - all fill handle options
by Maria Azbel | updated on March 4, 2021 134 Comments
This post looks at the AutoFill Excel feature. You will learn how to fill down series of numbers, dates and other data, create and use custom lists in Excel 2019, 2016, 2013 and lower. This article also lets you make sure you know everything about the fill handle, cause you may be surprised how powerful this tiny option is.
When you are pressed for time, every single minute counts. So you need to know every way to automate daily spreadsheet tasks. AutoFill in Excel is a popular feature, and I'm sure most of you already use it. However, it may be a new fact for you that it's not only about copying values down a column or getting a series of numbers or dates. It's also about creating custom lists, double-clicking to populate a large range and much more. If you know where the fill handle is located, it's high time to find out all the benefits it stores.
Below you see a plan of the post. Just click on the link you find especially interesting to get right to the point.