view the formula
 

How can I see what is the formula to a link cell?
For example, Sheet1, cell "A1" is linked to Sheet2, Cell"A1". In sheet2,
cell A1 has a formula like =VLOOKUP(N97,'LP Transactions'!$R$153:$R$324,1,0).

The result I like to see on Sheet1, cell A1 "=VLOOKUP(N97,'LP
Transactions'!$R$153:$R$324,1,0)".


Thanks,
Dinesh

view the formula
 

If I understand correctly, you just want to see the formula within the cells.

Click CTRL~ to view formulas.

"Dinesh" wrote:

How can I see what is the formula to a link cell?
For example, Sheet1, cell "A1" is linked to Sheet2, Cell"A1". In sheet2,
cell A1 has a formula like =VLOOKUP(N97,'LP Transactions'!$R$153:$R$324,1,0).

The result I like to see on Sheet1, cell A1 "=VLOOKUP(N97,'LP
Transactions'!$R$153:$R$324,1,0)".


Thanks,
Dinesh

view the formula
 

Hi,
go to Formulas, and under the formula auditing tab click on Show formulas
Hope this helps

"Dinesh" wrote:

How can I see what is the formula to a link cell?
For example, Sheet1, cell "A1" is linked to Sheet2, Cell"A1". In sheet2,
cell A1 has a formula like =VLOOKUP(N97,'LP Transactions'!$R$153:$R$324,1,0).

The result I like to see on Sheet1, cell A1 "=VLOOKUP(N97,'LP
Transactions'!$R$153:$R$324,1,0)".


Thanks,
Dinesh

view the formula
 

None of this work

"Eduardo" wrote:

Hi,
go to Formulas, and under the formula auditing tab click on Show formulas
Hope this helps

"Dinesh" wrote:

How can I see what is the formula to a link cell?
For example, Sheet1, cell "A1" is linked to Sheet2, Cell"A1". In sheet2,
cell A1 has a formula like =VLOOKUP(N97,'LP Transactions'!$R$153:$R$324,1,0).

The result I like to see on Sheet1, cell A1 "=VLOOKUP(N97,'LP
Transactions'!$R$153:$R$324,1,0)".


Thanks,
Dinesh