Delivered Fridays. He's covered a variety of topics for over twenty years and is an avid promoter of open source. For more news about Jack Wallen, visit his website jackwallen Watch Now. Delivered Fridays Sign up today. Editor's Picks. The best programming languages to learn in One of the most popular questions is how to autofill numbers is Excel.
This can also be dates, times, days of the week, months, years and so on. In addition, Excel's AutoFill will follow any pattern. For example, if you need to continue a sequence, just enter the first two values into the starting cell and grab the fill handle to copy the data across the specified range. You can also auto-populate any arithmetic progression sequence where the difference between numbers is constant. It will even alternate sequences if the selected cells don't relate to each other numerically, like on the picture below.
And it goes without saying, that you can use the AutoFill option to copy a value across your range. I think you already know how to make the same value appear in the adjacent cells in Excel. You just need to enter this number, text, or their combination, and drag it across the cells using the fill handle. Presume you have already heard of the features I described above. I still believe, some of them appeared new to you.
So go on reading to learn even more about this popular yet under-explored tool. Suppose you have a huge database with names. You need to assign a serial number to each name. You can do it in a flash by entering the first two numbers and double-clicking the Excel fill handle. It's not a problem for the AutoFill option to copy across the values that contain both text and numerical values. Moreover, Excel is quite smart to know that there are only 4 quarters or that some ordinal numbers need the corresponding letter suffixes.
If you use the same list every now and then, you can save it as a custom one and make Excel fill handle populate cells with the values from your custom list automatically. Please follow the steps below to do this:. Since you already selected the range with your list, you will see its address in the Import list from cells: field. Press the Import button to see your series in the Custom Lists window. When you need to get this list autofilled, enter the name of the header into the necessary cell.
Excel will recognize the item and when you drag the fill handle in Excel across your range, it will populate it with the values from your list. Use the AutoFill option to get repeating series If you need a series of recurring values, you can still use the fill handle. First, enter all these values manually to give Excel a pattern. Then just grab the fill handle and drag it to the necessary cell.
Most likely, you use AutoFill to populate cells down a column. However, this feature also works if you need to extend a range horizontally, leftward or upward. Just select the cells with the value s and drag the fill handle to the needed direction. The Excel Autofill can deal with data in more than one row or column. I have the same question Report abuse. Details required :. Cancel Submit. Princess Mat Microsoft Agent. Refer to the screenshot below: Let us know if the above solutions work for you or if you need additional assistance.
How satisfied are you with this reply?
0コメント