#Easy numbering xcel series
Note: also see the options to fill the formatting only and to fill a series without formatting.ġ2. Instead of filling in days, use the AutoFill options to fill in weekdays (ignoring weekend days), months (see example below) or years. AutoFill automatically fills in the days.ġ1. Select cell A1 and drag the fill handle down. AutoFill automatically fills in the day names.ġ0. AutoFill automatically fills in the product names.Ĩ. AutoFill automatically fills in the month names.Ħ. Note: AutoFill automatically fills in the numbers based on the pattern of the first two numbers.Ĥ. The fill handle is the little green box at the lower right of a selected cell or selected range of cells. Select cell A1 and cell A2 and drag the fill handle down. For example, enter the value 10 into cell A1 and the value 20 into cell A2.Ģ. For example, enter the value 10 into cell A1 and the value 20 into cell A2.1.
This page contains many easy to follow AutoFill examples.ġ. Use AutoFill in Excel to automatically fill a series of cells. If you know where the fill handle is located, it’s high time to find out all the benefits it stores. It’s also about creating custom lists, double-clicking to populate a large range and much more. 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.
AutoFill in Excel is a popular feature, and I’m sure most of you already use it.
So you need to know every way to automate daily spreadsheet tasks. When you are pressed for time, every single minute counts.
0 kommentar(er)
