|
|
|
Home > Excel Tutorials > How to Display Formulas in an Excel Worksheet How to Display Formulas in an Excel WorksheetAlmost everyone who has used Microsoft Excel would have at some time created formulas. The trouble is that the more complicated the formula, the harder it is to check. There are several ways to display formulas under Excel.Displaying formulas in the Formula BarThis is the most common method. Locate the Formula Bar menu item under the View menu and ensure that a check mark appears next to it. If there is no check mark, click on the Formula Bar to enable it. Next, click on a cell containing a formula. View the formula in the Formula Bar (Fig. 1). Fig. 1 - Formula Bar Displaying formulas inside cellsClick on the Tools menu and select Options (Fig. 2). In the Options dialog box (Fig 3.), select the View tab. Under the section labeled Window options, click on the Formulas check box to enable it. Click on the OK button. Fig. 3 - Options dialog box Alternatively, you can easily access this feature by pressing the Ctrl key and the left apostrophe key (grave accent) at the same time. The grave accent is located on the far left of the number keys on the keyboard. Pressing the Ctrl and the grave accent keys again will toggle the formula display off. A consequence of enabling the formula display is that you will not be able to see the calculated values at the same time. Another side effect is that the column widths change to accommodate short but not long formulas. In order to view long formulas you will either have to change the column widths manually or view the formulas using the Formula Bar. Using the Go To Special dialog boxIf the Excel worksheet is unprotected, you can press the Ctrl and G keys at the same time to open the Go To dialog box. Next click on the Special button (Fig. 4) in the Go To dialog box. The Go To Special dialog box will open. Click on the Formulas radio button (labeled "a" in Fig. 5) in the Go To Special dialog box and then click the OK button. This will select all cells in the worksheet that have formulas. Press the tab key to toggle through the selected cells and view the formula in the Formula Bar. Fig. 4 - Go To dialog box  Fig. 5 - Go To Special dialog box If the worksheet is protected, the Special button in the Go To dialog box will be grayed out. You will have to unprotect the worksheet in order to access the Go To Special dialog box.
|
Other Tutorials |
||||||||||||||||
UltraSleuth
