You will need
- The table editor Microsoft Office Excel 2010 or 2007.
By default, each table cell, Excel applies the format, which is called "General". It implies that the equal sign at the beginning of the cell contents, means that it the formula is placed. It is inconvenient, if in fact the sign of equality is only part of the text. In such cases, the tabular editor usually shows instead of the text of the error message in the formula. You can correct the problem by changing the cell format to "text". To do this, start with selecting the desired table area - column, row, or group of cells.
Open the drop-down list placed in the group header row of teams, the "Number" on the "General" tab of the application menu. Scroll to the bottom and select the bottom line is "Text". The same can be done another way - click the selected range, right-click and select "Format cells" from the context menu. Click on "Text" in the list of "number formats" and click OK. The procedure is completed.
If cells display formulas instead of results of their work, apparently, you should change one of the settings Excel. To do this go to the Formulas tab and click the "Show formula" - it is placed to the right of the caption "Impact cells" in the group of teams "based on formulas". This icon is in the on state needs to be highlighted in yellow.
This defect is repeated every time the document is opened, if this option is recorded in the settings of Excel. To change the appropriate setting, open the main menu of the table editor and select "Options". In the list of topics, click on "Advanced" and scroll down the settings list to the section "Display options for this worksheet". In the "Show formulasinstead of their values" to remove the checkmark and click OK. When you close the document, don't forget to save that situation is not repeated the next time you load in the table editor.
Advice 2 : How to remove a formula in Excel
Excel gives you the ability to produce various calculations, including analytical. The program allows you to create your own formulas or use built-in functions. But often you want to save the final result in stable form. Or do you just not want the other user to see the formulas that were calculated. In these cases, use the save as values.
If you need to remove the formula in one particular cell, set the cursor of the mouse and press the left key. In the function bar (just under the toolbars) lights up a formula that calculates the value in the cell.
Press the right mouse button. Appearing context menu. Activate the setting to "Copy" around the cell should appear with a dotted frame. Again right-click. In the popup again, select "paste Special". A new window opens with options for inserts. The left mouse button, select "values" or "values and number formats". Then click "OK". You will see that in the function bar instead of the formula had been the result.
You can change the formulas to values in several cells. For this we first need to highlight these cells and then repeat the actions described in step 2.
To change formulas to values for the entire row or column, you must first allocate the entire relevant area. To do this, move the cursor to the upper border of the sheet with the names (letters) of the columns or the left margin with line numbers and install it at the right level so that the pointer changes to a black arrow. Then click on the left mouse button and see that the entire row (column) is highlighted. Follow the algorithm of section 2 of this manual.
If you want to keep all the calculations in the worksheet as values, move the cursor to the upper left corner of the sheet. When you see, as highlighted in the corner of the square, press the left mouse button. The result is highlighted in the entire work area. Repeat the sequence from step 2.
After you save the file with the "values" you will not be able to recover the formulas on which the calculations were made. Therefore, it is better, just in case, make a copy of the original file and save it without formulas.
Advice 3 : How to display Excel formulas
To see the formula placed in the cell of the spreadsheet Microsoft Office Excel can be, if you enable edit mode. It appears in the formula bar open sheet. However, sometimes you need to look at the algorithm for computing values in a single cell and in all cells of the table. In Excel the possibility of replacing display values in rows and columns calculate their formulas.
You will need
- The table editor Microsoft Office Excel 2007 or 2010.
Run the table editor, load a document, the formula of which you are interested in, and open the desired sheet.
Go to the tab "Formulas" menu in Excel. You need button placed in the group of teams "based on formulas", but no inscriptions on it are not displayed, and the picture to identify the purpose is not so simple. Focus on the word "precedents" - need an icon placed to the right and if you hover the mouse pointer POPs up a tooltip with the title "Show formula" and a short explanation of the purpose. Click this button and Excel will replace the values with formulas in those cells where these formulas are available. This changes the formatting of all columns - they will be much wider.
To return the table to the welcome view, click on the same icon again. You can try instead of a button for on and off the display of the formulas use a combination of Ctrl key and a service key with the tilde ~ (in Russian layout - Litera E). Reference materials Microsoft claim that this combination should work, but it is not always the case.
If you require not a single inclusion, and a continuous display formulas instead of values in the current sheet or throughout the document, change the appropriate setting in the settings table editor. To do this, first in the main menu of the application select "Options" (Excel 2010) or click Excel Options (Excel 2007).
In the column listing the sections, select "Advanced" and then scroll through a long list of settings to half. A little below the middle there is a section called "Display options for this worksheet". Select the worksheet or the whole document in the drop-down list next to the option, and then click "Show formulasin cells instead of their values". Click OK and the formula will appear in the spreadsheet cells.