![]() ![]() ![]() It easy to auto-complete a list or copy a formula for a few dozen cells in a row/column using the fill handle. ![]() ![]() You can find the fill handle at the lower right-hand corner of the selected cell(s).įor instance, if we enter numbers or alphabets, or dates in at least 2 cells of a range with a pattern, and when we select those cells and drag the fill handle down or across the cells, the series is automatically filled. The Fill Handle is an Autofill feature in Excel that enables you to fill up a series of values or copy formulas to a desired number of cells by simply dragging it using the mouse. If you have thousands of cells to autofill in Excel, you can use the Fill Series tool or Name box to fill your data without dragging the fill handle. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |