answersLogoWhite

0


Best Answer

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

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you display a formula so you can edit it?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

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


When you edit HTML code the internet explorer does not display the changes?

When you edit the code you need to press the refresh button on the browser!


When you create a new folder the folder name display?

edit mode


What is a cell content on Excel?

It is what is contained within the cell, such as formulas, functions, letters, numbers, symbols, etc. After typing something in, you may see something else, like the result of a calculation by a formula. This is the cell display. So if you type in a formula, it is the cell content, but it will display a result. In reality it is the formula that is in the cell, not what is displayed. So different results will show if values used by the formula change.


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

formula


How do you edit a formula in Excel?

Click on the cell containing the formula and edit within the cell or in the cell bar at the top of the screen. You can do that by clicking in the formula or pressing the F2 key.


Who can edit my imvu display picture xD?

Depends on how much you want to pay me.


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.


What is cut text saved to?

Cut text is saved in so called clipboard or cache memory.You can display it using toolbar menu - Edit - Office Clipboard.


What is the area of the excel window in which you enter and edit data?

cell or formula bar!