Formula Bar and also Name Box: simply under the Ribbon is the Formula Bar with the Name box to the left. In Figs. 1.3 and 1.4 the Name crate is displaying E6. Girlfriend will notification that both the E column and the 6 row headings room highlighted and that the cell at the intersection the this column and also row is picked out by a border. We call E6 the active cell, and we say that the name Box screens the referral (or address) the the energetic cell. As soon as the energetic cell consists of a literal meaning (text or number), the Formula Bar additionally displays the very same thing, however when the cabinet holds a formula then the formula bar display screens the yes, really formula if the cell generally screens the result of the formula. Fast experiment: form B4 in the name box and press ; note how this takes girlfriend to cell B4.

You are watching: The formula bar displays the value or formula of the active cell

Note: the is ending up being common to talk around tabs when worksheets are meant. This is really poor practice due to the fact that it can cause confusion and also will not advantage a user looking in Help.

Bernard V. Liengme, David J. Ellert, in A overview to Microsoft Excel 2007 because that Scientists and also Engineers, 2009

Display Formulas

As stated before, the brief cut

(where ′ is the an essential to the left that 1 top top the peak row the the keyboard) causes the worksheet to display formulas not values. The shortcut is a toggle—use the the second time to return to values.

To “capture” a cell's formula for display in one more cell or in an additional application such together Word:


With the source cell selected, use the mouse to highlight the entire formula in the formula bar. Usage the

faster way to copy it come the Clipboard.



key. This is many important; otherwise the cabinet formula will be compromised.


Move to wherein the formula is required and use the normal paste command. If the target is one Excel cell, you have to precede it through an apostrophe to have actually it screen as text. Otherwise girlfriend will have actually just duplicated the formula however with no referral adjustment, which have the right to sometimes it is in useful.

Note the this is a static procedure, definition that a readjust in the resource cell will not an outcome in a change in the presented version. Because that a quicker and also dynamic solution, one have the right to use the following UDF.

If this is placed in the Personal.xlsb file, it will be available in all other workbooks. It would be discovered in the Insert Function dialog in the User Defined classification as Personal.xlsb!Showform.

Bernard V. Liengme, in A overview to Microsoft Excel 2013 for Scientists and Engineers, 2016

The Insert function Command

therefore far, we have composed recipe with features using the AutoSum tool. The Insert role tool gives us with accessibility to a greater variety of functions. Us may accessibility it either v the symbol (fx) the is situated to the left the the formula bar or through the command Formulas / role Library / Insert Function. Either means opens the dialog displayed in figure 4.3. In ~ this, friend may choose the function you great to use, find out a tiny of what it does, and also insert that is arguments. The find box offers some restricted help in locating a function based top top what friend type, however it is not really intelligent. The categories box permits you to filter the list of features to just one group or to a list of recently used functions. In the next exercise, we see exactly how to usage the dialog to produce a formula include a function.

See more: How Many M&Amp;Ms In A Pound, How Many Meters Are 1000 Centimeters

When girlfriend become much more familiar through the functions, you deserve to use one of the other tools in the Formulas / duty Library team to situate a role based top top its category—see number 4.4.