Can you create Duplicate Cell and linked to original Sheet to hide original sheet's Formula?

Rafsun Royal · 11/04/18

Currently I am working to create a statistics to show all the work status counts. I am using multiple formulas in different cell. Is there any way to hide the formulas OR create a duplicate linked sheet where the duplicate sheet will update at the same time when I will change anything to my worksheet( Main sheet, that I am using as a reference sheet for my formulas)

Pease let me know if I can clarify anything.

Thanks in Advance!

Andrée Starå · 11/04/18

Hi Rafsun,

You can cell link to another sheet or another cell in the same sheet and that information will update at the same time as the main data. You could also show the information in a dashboard.

Would that work?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Rafsun Royal · 11/04/18

Andrée Starå

I have tried that but the only problem is the new linked sheet also shows the formulas in I click any cell.

Is there any way that, I can just view the data but not the formulas.

Thanks Much!

Rafsun

Can you create Duplicate Cell and linked to original Sheet to hide original sheet's Formula?

Comments

Categories