-
To see Auto Fill Options, select a data range and drag the cross (+) in the lower-right corner.
-
Select Auto Fill Options , and choose the type of fill to use in the selected cells.
Setting Auto Fill Options isn't currently possible in Excel for the web. You can, however, Set Auto Fill Options in the Excel desktop app.
-
To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.