Forum Discussion

Lawrence_CowleyFGTas's avatar
Lawrence_CowleyFGTas
Copper Contributor
Jan 10, 2022
Solved

Linking cells containing text

I am using Excel 2016.  My role is industry development for the fruit industry in Tasmania.  We have a rudimentary members list on Excel with company name, key contact persons, phone, email etc.   ...
  • HansVogelaar's avatar
    Jan 10, 2022

    Lawrence_CowleyFGTas 

    1. Make sure that the cell is not formatted as Text. If it is, format it as General, then select the cell, press F2 and Enter.
    2. Make sure that Show Formulas in the Formula Auditing group of the Formulas tab of the ribbon is not highlighted.

Resources