![]() ![]() Use Drag-fillĬlick on a cell containing a value or formula that you want to copy into adjacent cells. Learn more about this functionality in Auto-filling Formulas and Formatting article. ![]() ![]() When you use drag-fill with a formula, the cell references will adjust automatically to reflect the new placement.Ī formula will automatically be filled in to a cell if it's directly above, below, or between two cells that contain the same formula. Drag-fill Basicsĭrag-fill will copy a value or formula from one cell into other adjacent cells. You can quickly fill a range of cells with a series of numbers, dates, or a text string ending in numbers, that’s either sequential or an evenly spaced interval using the drag-fill method.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |