-
On your Excel worksheet, select the View tab.
-
Select the Formula bar checkbox.
The formula bar is always on in Excel for the web.
You can, however, show or hide the formula bar in the Excel desktop app.
-
To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.