how to show formula in formula bar

cattywampus · Jun 10, 2005

How do I make the formula show in the formula bar and keep it there?

Bernie Deitrick · Jun 10, 2005

Select the cell with the formula.

HTH,
Bernie
MS Excel MVP

Bill Kuunders · Jun 11, 2005

go to

tools<>options<>view<>
and tick the formula bar