I am not sure what you want.
If you want to see just the formulas goto <tools<options<view and click
on window options formulas
this will effect the enverything
for certain cells you can copy the cell and add a "'" infront of where you
paste it.

"J. Freed" wrote:

I have a client who wishes to replace the sheet names in his cells with the
formulas they reference. I can see how you go from formula to sheet name, but
how about the other way around?

TIA......