The second option is to shorten the names on the tabs; that will allow more to show at the bottom of the screen. Notice in the screenshot above how little space the number 2 takes compared with ...

To display the formulas in the sheet instead of the results in Excel, you can go through the steps above. First, open the Excel Options panel and go to the Advanced tab.