Forum Discussion

Arcade_Printing's avatar
Arcade_Printing
Copper Contributor
Jan 18, 2023

auto fill a row in excel 2016 without formulas

need help on how to do this, see screenshot

 

  • dscheikey's avatar
    dscheikey
    Bronze Contributor

    Arcade_Printing 

    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?

     

Resources