A site by Mehul Thakkar
All blogs
Let's go

Formulas are visible instead of Results in excel

Table of Contents

Issue

Often we face the issue where even after pressing “Enter”, the formula is visible instead of the results.

Solution

Press Ctrl ~ to switch back to normal mode. 

Reason

This happens due to the formula view being enabled by mistake at times by pressing Ctrl ~

Share this post with your friends