ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Display Formula (https://www.excelbanter.com/excel-discussion-misc-queries/162841-re-display-formula.html)

Bernard Liengme

Display Formula
 
Are you working with Excel 2007?
If cell A10 has =SUM(A1:A10), and you move to cell A10, what do you see in
the Formula Bar?
The fx is still in XL2007; it is used to add a function to a formula
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"hoss" wrote in message
...
In a previous version of Excel, on the tool bar there was a function Fx
cell
that display'd the function in a cell. If the cell did not contain a
function it would display the contents of the cell. This was handy if the
contents of the cell went beyond the boundaries of the cell. I can not
figure out how to get this back. Does anyone have any ideas?
--
hoss





All times are GMT +1. The time now is 01:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com