Fill data into adjacent cells
To perform fill series on a cell range:
Select the cell range on which you wish to fill the data, including source data as the first cell.
Go to
icon Under Data menu, choose Fill.
Choose the direction in which you wish to fill the data.
Note: You can also tap on the desired range and choose Fill from the context menu.