![]() ![]() All we need to do is highlight both cells A1 and B1, then drag the B1 Fill Handle until we get to "Dec."īecause we made cell A1 our active cell, Excel recognizes that “Jan” followed by “Feb” most likely refers to the “January, February…” series. ![]() We’d like to enter the remaining months of the year in the columns to the right. On the worksheet below, we’ve entered “Jan” in cell A1 and “Feb” in cell B1. In this case, you'd probably rather have it auto-populate than subject yourself to the tedium of manual entry. The pattern may be a trend in numbers, days, or months that increase or decrease by a certain value. Use the Fill Handle to auto-populate values in a seriesĪt other times there's an obvious pattern that needs to be completed. If we go to cell B5 and drag the Fill Handle all the way to cell B9, the prices of orchids, peonies, roses, and tulips will now be changed to $19. To illustrate how this works, take a look at this list of flowers and their prices. ![]() If they have values, those values will be overwritten. This works whether the cells within the range to be filled were empty or they contained values. The Fill Handle can be used to replicate a value simply by going to the cell which has the desired value and dragging the Fill Handle to the cells where you want that same value to appear. Use the Fill Handle to copy the same value This feature is useful for copying values or formulas to adjacent cells. When you hover over the Fill Handle, the pointer changes to a small black plus sign.ĭragging or double-clicking on the Fill Handle will activate AutoFill This is a small green square at the bottom right corner of the active cell. ![]() Ready to learn how to recognize when Excel is giving you a helping hand? The Fill HandleĮvery active cell (that’s the one that your cursor is currently sitting in) has a Fill Handle. AutoFill shows up in different ways - sometimes by copying a formula to adjacent cells, at other times completing a list of days or months, or even by observing a formatting pattern and applying it to empty cells. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |