Link cell

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

How I can link one cell from one sheet to other sheet.
The result that I am geting is only ='01 PSW'!A6:F6 and
not real value like "pole piece"
 
You don't need any parentheses. It sounds more like one of the following scenarios:-

1) The cell was formatted as text prior to entering the formula. Fix - Format the cell as
general and with that cell selected, hit F2 then hit Enter.

2) The spreadsheet is set to display formulas. Fix - Tools / Options / View Tab / Uncheck
'Formulas' in lower portion of dialog box.
 
Back
Top