Translate

Monday, December 29, 2014

Show formula in Excel in specific cells without activating show formula option:

Show formula in Excel in specific cells without activating show formula option:
Someone asked me about following table. How the Expression column in this table shows formula without activating Show formula option in Formula Tab à Formula Editing? In this column he access any cell in edit mode after lock the entry in the cell Excel shows the result instead of underlying value in that cell.
I solve above mention problem in following steps:
If you want to show formula in excel cell first select the cells


Then convert its category General to Text
 
After that type the formula: this formula extract Title from the Name of the Student

Now you are able to view the formula. If you want to convert it into formula to calculate by Excel you select the cells again

And convert its category text to general
Active any cell in expression column and press F2 key

and press Enter key Excel now calculate it.

 
Or if there are already formulas in cells and you want to view it without using the show formula option/ (Ctrl+`) (`acute accent key) or you want to view only specific cells not all in the sheet:
Step1: select the cells
Step2: change their category into Text
Step3: make it active and press F2 and lock the entry
Now it will show the formula……….



Tell us what we can do to improve this article

Please comment if you like it, or have any
suggestions.



Posted by at

30 comments:

  1. UnknownFebruary 9, 2015 at 1:39 PM

    good explanation truley apreciable

    ReplyDelete
  2. UnknownFebruary 9, 2015 at 1:42 PM

    right way to explain

    ReplyDelete
  3. UnknownFebruary 9, 2015 at 1:43 PM

    magic complex problem with a simple solution ....
    thank you sir

    ReplyDelete
  4. Jitendra TailorFebruary 9, 2015 at 1:44 PM

    topper of the class

    ReplyDelete
  5. harshit905February 9, 2015 at 1:45 PM

    Easy and understandable..Explanation..! .

    ReplyDelete
  6. UnknownFebruary 9, 2015 at 1:45 PM

    thank you sir for this useful post.. :)

    ReplyDelete
  7. UnknownFebruary 9, 2015 at 1:46 PM

    this was a good explanation and so short.

    ReplyDelete
  8. UnknownFebruary 9, 2015 at 1:47 PM

    Nice its great its very sort thanks sir

    ReplyDelete
  9. UnknownFebruary 9, 2015 at 1:48 PM

    gud explanation........sir......

    ReplyDelete
  10. poornima vijayFebruary 9, 2015 at 1:48 PM

    thank you sir for dis post!! :)

    ReplyDelete
  11. AYUSHFebruary 9, 2015 at 1:48 PM

    This comment has been removed by the author.

    ReplyDelete
  12. UnknownFebruary 9, 2015 at 1:48 PM

    gud explanation........sir......

    ReplyDelete
  13. AYUSHFebruary 9, 2015 at 1:50 PM

    IT WAS A NYC EXPERIENCE

    ReplyDelete
  14. UnknownFebruary 9, 2015 at 1:50 PM

    easy way for the complex problem

    ReplyDelete
  15. UnknownFebruary 9, 2015 at 1:55 PM

    superb sir u r the genious

    ReplyDelete
  16. UnknownFebruary 27, 2015 at 12:21 PM

    thank you sir it is really helpful, (y)

    ReplyDelete
  17. RexdipeeFebruary 27, 2015 at 12:22 PM

    ;'']/.;''// what AN iDEa sir ji ..;;,;., superb ;;..'

    ReplyDelete
  18. UnknownFebruary 27, 2015 at 12:27 PM

    thank-you sir for providing us with such a simple solution

    ReplyDelete
  19. UnknownFebruary 27, 2015 at 12:27 PM

    nice....

    ReplyDelete
  20. UnknownMarch 30, 2015 at 10:34 AM

    easy way for the complex problem, thanks sir

    ReplyDelete
  21. UnknownMarch 30, 2015 at 10:38 AM

    Its a good way to make other people understand what formula is required and what result it generates. Thanks Sir.

    ReplyDelete
  22. UnknownApril 23, 2015 at 5:23 PM

    Thanks sir for providing such a useful knowledge.

    ReplyDelete
  23. UnknownApril 23, 2015 at 5:24 PM

    Great Work sir

    ReplyDelete
  24. UnknownApril 23, 2015 at 5:25 PM

    thank-you sir for providing us with such a simple solution

    ReplyDelete
  25. UnknownApril 23, 2015 at 5:25 PM

    This comment has been removed by the author.

    ReplyDelete
  26. UnknownApril 23, 2015 at 5:26 PM

    Sir This is Advance Idea For Advance ITT
    Thanks

    ReplyDelete
  27. UnknownApril 23, 2015 at 5:27 PM

    Genius Think like as you sir...

    ReplyDelete
  28. UnknownApril 23, 2015 at 5:29 PM

    thank u sir,
    for provide simplest solution of complex situation.

    ReplyDelete
  29. UnknownApril 23, 2015 at 5:30 PM

    superb... great job sir..thank u so much for adding to our knowledge..

    ReplyDelete
  30. UnknownApril 23, 2015 at 5:44 PM

    Nice......It makes me able to applying the formula without learning......Thankuuu Sir...

    ReplyDelete

Subscribe to: Post Comments (Atom)