How do I know about export same word in every sheet of the excel file?
I want to know keep the description of the item's same in every sheet that I linked to work in an excel file, but every time I paste the same formula in every sheet it shows #Ref, I need to know the solution.
1 Answer
=sheet1!A1
If the item is on sheet1 and cell A1
Just paste "=sheet1!A1" on every additional sheet.
Hope is of some help.
