answersLogoWhite

0

There are a few things you can do. Go to the Tools Menu, then pick Options, the View and down near the bottom left there is a tickbox beside Formulas. If you tick it and then click OK, all your formulas will be displayed. One problem is that it will widen out some of the columns in order for the formulas to show properly. So if you don't want that to happen and are just interested in seeing one particular formula, then to see an individual formula, just click on the cell and the formula will be shown in the formula bar near the top of the screen. Another option is to press the F2 key when you are on the cell and it will show the formula in the cell.

There is also an option to select cells that are formulas. Open the Edit Menu and click Go To. Then click Special. There is an option there that you can click that will highlight the cells that have formulas.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the general formula that can be used to identify carbohydrates?

The general formula to identify carbohydrates is (CH2O)n, where "n" represents the number of carbon atoms in the molecule.


Identify the number and kinds of atoms presented in ascorbic acid?

Ascorbic acid, also known as Vitamin C, has the chemical formula C6H8O6. It contains 6 carbon atoms, 8 hydrogen atoms, and 6 oxygen atoms.


Elements a compound contains and the exact number of the atoms of each element in a unit of that compound is called what?

The elements a compound contains and the exact number of atoms of each element in one unit of that compound is referred to as the chemical formula of the compound.


How do you identify the number of elements in a compound?

The number of elements in a compound can be determined by looking at the chemical formula and identifying each element's symbol. For example, the compound CO2 has two elements, carbon and oxygen. Another example, glucose, has the formula C6H12O6, and has three elements, carbon, hydrogen, and oxygen.


What tells what elements a compound contains and the exaxt number of each element in a unit of that compound?

a chemical formula


What is total number of elements in formula C6H12?

C6H12 contains only two Elements, Carbon (C) and Hydrogen (H). It contains 6 atoms of Carbon, and 12 atoms of Hydrogen OR a total of 18 atoms.


How many hydrogen atoms are in 6.00 mol of ammonium sulfide?

The formula unit for ammonium sulfide has the formula (NH4)2S. This formula shows that the formula unit contains two ammonium ions, each of which contains four hydrogen atoms. The total number of hydrogen atoms is therefore 8.


Is it possible to insert a number into a Microsoft excell cell with a formula already in the cell automatically generating an answer without having to write the formula everytime?

If a formula is in a cell and a number is entered into the same cell, then the formula will be gone and replaced by the number. You can enter a number in a cell that is referenced by a formula in another cell. The cell with the formula in it will update when the number is entered into the other cell. Say you change the value in A2 and the cell A3 contains the formula: =A2*10 Then the total in A3 will update when any change in A2.


How do you identify the number of jewels in a watch?

The number of jewels in a watch refers to the number of individual gears it contains. Other than opening it and counting, you may be able to look up the number by the make and model of the particular watch.


The number 2 in the formula h20 tells you that each unit of this compound contains two?

Hydrogen atoms


How to identify a 1986 Mazda 2000 F engine as opposed to a 1987 Mazda 2200 F2 series engine?

where the engine number is located it will have FE for 2000 and F2 for 2200


How do you identify the slope and y intercept of the line?

we use the formula y = mx + b where m is the slope and its the number multiplied by x, any other number is the y-intercept