ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add the formula bar? (https://www.excelbanter.com/excel-worksheet-functions/253282-how-do-i-add-formula-bar.html)

tysiesmoma

How do I add the formula bar?
 
I've recently switched computers and now my Microsoft Excel does not display
the formula bar at the top of the page. It is much easier to edit long
formulas in the bar rather than in the cell. How can I add it?

Luke M

How do I add the formula bar?
 
Tools - Options - View. Place a check in the box next to "Formula bar".
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tysiesmoma" wrote:

I've recently switched computers and now my Microsoft Excel does not display
the formula bar at the top of the page. It is much easier to edit long
formulas in the bar rather than in the cell. How can I add it?


trip_to_tokyo[_3_]

How do I add the formula bar?
 
IN EXCEL 2007:-

View / Show/Hide group / select or de-select the Formula Bar box.

If my comments have helped please hit Yes.

Thanks.

"tysiesmoma" wrote:

I've recently switched computers and now my Microsoft Excel does not display
the formula bar at the top of the page. It is much easier to edit long
formulas in the bar rather than in the cell. How can I add it?



All times are GMT +1. The time now is 07:04 PM.

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