Donate SIGN UP
Home > Business & Finance > In Msexcel, How Do I Make The Field – Which Generally Appears At The Top Of The Spreadsheet – Display Cell Content (E.g., Formulas)?

In Msexcel, How Do I Make The Field – Which Generally Appears At The Top Of The Spreadsheet – Display Cell Content (E.g., Formulas)?

Avatar Image
gentleman2222 | 23:04 Thu 07th Nov 2019 | Business & Finance
5 Answers
In MSExcel, how do I make the field – which generally appears at the top of the spreadsheet – display cell content (e.g., formulas)?
prev Question About Starting A Software Engineer Professional Development Program
  
next Help To Buy Isa
Gravatar

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by gentleman2222. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image Calibax
Do you mean you want the cell to show "=(a1*3)" for example rather than the value of the formula?
Try formatting the cell to text rather than general.
23:10 Thu 07th Nov 2019
Avatar Image THECORBYLOON
When you click on the cell, does it not show the formula in the formula bar?
23:21 Thu 07th Nov 2019
Avatar Image New Judge
In the latest version There is a "Formulas" Tab at the top. Click that and about three quarters of the way along the top is "Show Formulas". Click that and all your cells will show formulas instead of values. To reverse back to values simply click "Formulas" again.

There are similar options in earlier versions though I cannot remember the details.
16:07 Sat 09th Nov 2019
Avatar Image Peter Pedant
the keystroke is either f2 or f4
.
yeaah sorry - f4 willl make the reference stick by putting a dollar sign in front $
and f2 toggles the "show formula" command

you tube - xcelisfun - mike girvin does a lot about excel in a shock-jock mode - " prrrp! how cool is that? show your friends!). All for free,
he has more than one vidd on keystrokes instead of mouse
16:18 Sat 09th Nov 2019
Avatar Image New Judge
Hitting F2 shows the current selected cell in formula form. Clicking away from that cell returns it to values.
20:27 Sat 09th Nov 2019

1 to 5 of 5rss feed

Do you know the answer?

In Msexcel, How Do I Make The Field – Which Generally Appears At The Top Of The Spreadsheet – Display Cell Content (E.g., Formulas)?

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.