How to link a cell to a text box with excel online?

Copper Contributor

Hi there,

 

I am trying to link a cell to a text box so that I can display a number inside a circle. The number is constantly changing which is why I want to link it to the cell.

 

I've tried selecting the text box and then trying to select the formula bar, but it's greyed out and not an option.

 

I tried with the desktop excel and it works fine, so not sure if the feature isn't available on excel online. 

 

Anyone had success doing this or another other way of linking a cell to a text box?

 

1 Reply

@Danepad I also don't see that capability in the webapp yet.  

 

Perhaps a feasible workaround in the interim could be merging cells and using a transparent circle as in:

 

DexterG_III_0-1663214332782.png

 

Hope this helps.  

Dexter