Displaying a single formula

Hi

The function to display formulas is CTRL ` this shows the formulas for the entire sheet.

Is there a way to display a formula on its own, without all the other formuals in the sheet being displayed? I have tried selecting a single cell and selecting CTRL ` but that dispalys all formulas on the sheet.

Many Thanks for your help

Rob

Hi

When you select a single cell with formula it displays in the formula bar

Chris

Thanks Chris

The reason for my question is that I need a speadsheet that displays the result of a formula in one cell and then on an adjacent cell the actual formula itself.

However I just realised if I take the equals sign off the start of the formula, it displays the text.

Thanks for your help
Rob