FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Or, sometimes the sheet is protected from showing formulas. The following steps will help you in these situations. To show the Formula Bar, click the View tab, and then click to select the Formula Bar check box. Tip: If you want to expand the Formula Bar to show more of the formula, press CONTROL+SHIFT+U.

Detailed explanation-2: -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. Microsoft Excel displays formulas in cells instead of their results right away. To get the calculated values back, click the Show Formulas button again to toggle it off.

Detailed explanation-3: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells.

Detailed explanation-4: -The formula bar displays information entered in the current or active cell. The contents of a cell can also be edited in the formula bar. The formula bar gets activated as soon as you type an equal sign in any cell or click anywhere within the bar.

Detailed explanation-5: -Excel formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx). You can use it to enter a new formula or copy an existing one.