![]() ![]() It identifies the pattern of the series from the two filled cells and fills the rest of the cells.The row number will get updated in case of addition/deletion of row(s).fill handle a number will appear automatically in serial order. Drag the + symbol manually till the last cell of the range or double click on the plus icon, i.e.The moment the cursor is kept on the cell, it changes to a plus icon.There is a small black box on the bottom right of the selected cell.Enter 1 in the A2 cell and 2 in the A3 cell to make the pattern logical. ![]() It helps in auto-populating a range of cells in a column in a sequential pattern, thus making the task easy.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |