Learn how to show formulas in cells instead of values or calculated results In Microsoft Excel. You can show or hide formulas in Excel cells.

Open the Workbook that’s having the issue and go to File > More… > Options. Excel Options window will appear. Click on the Advanced tab in the left panel.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.

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