Copy Cells – Copy the starting cell value all over the selected range.At the end of the selected cells range in the bottom right corner, there is an AutoFill Options box available (shown in the below screenshot).Excel will fill the selected cells by either repeating the value in the first cell or by inserting a sequence from the first cell and second cell.With the help of mouse drag, this Fill Handle across the cells to be filled.This tiny cross is a versatile tool in the Excel suite that can be used for data entry, data transformation, and many other applications. You will see that in the bottom right corner of the cell, there is a small square that’s called “ Excel Fill Handle Excel Fill Handle The fill handle in Excel allows you to avoid copying and pasting each value into cells and instead use patterns to fill out the information. Following are the steps of autoFill in excel –
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |