answersLogoWhite

0

It displays contents of the active cell.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Do the contents of the active cell display in the name box?

yes


What are the two ways to open a display dialog box?

ways to open a display dialog box


What action will not display the Choose a SmartArt Graphic dialog box?

Saving a file will not display the dialog box.


Where does the answer will display after entering the formula into the cell?

The answer will display in the cell itself.


Can I display a formula instead of the value in a spreadsheet?

To display the formula, not its results, in a cell, a user can choose a format for "text."


What can be assigned to a cell and will display calculated a result?

Formula


What does a box plot display?

stuff


In Excel what can be assigned to a cell that will display a calculated result?

formula


How do you display formulas in the worksheet cells rather than the formula results?

Click on the cell to view the formula in the formula bar at the top of the screen. If you would like to display the formula as text in a cell, instead of seeing the results of the formula, enter an apostrophe (') in front of the equal sign (=) of the formula. That will tell Excel to display the cell contents as text and not try to calculate the formula. To display all formulas at once, press and hold the Ctrl key and then press the ` key, which is in the top corner of your keyboard. There is also an option in the View menu to display formulas.


How many words can you put in a cell box?

It depends on the length of each word. The number of words does not matter; the limit is the number of total characters, including spaces. The maximum length of cell contents (text) is 32,767 characters. Only 1,024 display can display in a cell, but all 32,767 characters display in the formula bar.


How do you display a formula so you can edit it?

Click on the cell. Then press F2 or click in the formula bar to edit the formula.


How do you display find dialog box in excel?

By going to the insert tab, text box.