Microsoft Excel has a helpful behavior in regard to copying expressions. After entering a row or column of expressions, you can copy them, and Excel will update the cell references according.

Microsoft Excel displays all cell references by default. When you click on a cell, its column and row references are highlighted in the worksheet's column and row headings.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.