auto fill a row in excel 2016 without formulas

Copper Contributor

need help on how to do this, see screenshot


1 Reply


I would use a function like XLOOKUP() or VLOOKUP() in EXCEL 2016. If you don't want to have functions in these cells later, you can make fixed entries in the cells from the formulas with COPY and PASTE-VALUES.

Would that be a working solution?