The most common programs in which you have to edit documents containing tables are today applications from the office suite of Microsoft Corporation. It is a Microsoft Office Excel spreadsheet editor and a Microsoft Office Word word processor. Formulas in these programs are used in different ways, so the way they are displayed in table cells is also different.
Necessary
Tabular editor Microsoft Office Excel 2007 or 2010, word processor Microsoft Office Word 2007 or 2010
Instructions
Step 1
There are two ways to display formulas instead of their results in table cells in Microsoft Office Excel. The first one uses the general settings of the spreadsheet editor. To access them, open the menu by clicking on the File (2010) or Office (2007) button. Then select "Options" (in version 2010) or click on the button "Excel Options" (in version 2007).
Step 2
In the list of parameters, go to the "Advanced" section and check the box next to the "Show formulas, not their values" line in the "Show parameters for the next sheet" section. Click OK to complete the operation.
Step 3
Another way is using a special control placed in the tabular editor's menu. After navigating to the required sheet of the document, click on the tab "Formulas" in the application menu. In the Formula Dependencies command group, find the button you want - it is placed in the first row of a column of three icons in the center of this group, and when you hover over it, the Show Formulas tooltip pops up. Click on the button and the problem will be solved.
Step 4
In a word processor Microsoft Office Word, to display a formula in a table cell, you must either type it using special characters, or create it in the formula designer. The first method is suitable if the formula contains only characters that can be placed on one line, including superscripts and subscripts.
Step 5
You can access the table of special characters for your formula that are not on the keyboard through the "Symbol" button on the "Insert" tab - open its drop-down list and select the "Other Symbols" item. As a result, a table will open in which you can find signs of mathematical and physical symbols and operations, letters of the Greek alphabet, fractions, arrows, etc. To add any of them to the formula, select it and click the "Insert" button.
Step 6
Another way to display a formula in a table cell is to create it using a custom constructor. It is turned on by another button from the same group of commands, which is called "Formula".
Step 7
Click this button and Word will provide you with the tools to create your formula in an additional menu tab called "Working with Formulas: Constructor". In this variant, unlike the previous one, you are not limited to one line, but you can create structures with any number of "floors".
