Click on the Show Formulas button in the Formula Auditing section. Excel will then show you a preview of what your new columns will look like. Microsoft Excel displays formulas in cells instead of their results right away.
Show Formulas option on the Excel ribbon In your Excel worksheet go to the Formulas tab Formula Auditing group and click the Show Formulas button.
Show formula bar in Excel 2003 and XP In insert the formula bar in the old Excel versions go to Tools Options then switch to the View tab and select the Formula Bar checkbox under the Show category. Enter cell references with pointing. In our example lets choose the space. Show Formulas enabled To check if Show Formulas is turned on visit the Formula tab in the ribbon and check the Show Formulas button.