ExcelBanter - how to show formula in formula bar

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how to show formula in formula bar (https://www.excelbanter.com/new-users-excel/30179-how-show-formula-formula-bar.html)

cattywampus

how to show formula in formula bar

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

Bernie Deitrick

Select the cell with the formula.

HTH,
Bernie
MS Excel MVP

"cattywampus" wrote in message
...
How do I make the formula show in the formula bar and keep it there?

Bill Kuunders

go to

tools<options<view<
and tick the formula bar

--
Greetings from New Zealand
Bill K

"cattywampus" wrote in message
...
How do I make the formula show in the formula bar and keep it there?

All times are GMT +1. The time now is 05:13 PM.