Jan 24 2012

Excel shows Formula’s instead of Values

Category: Excel,Microsoft,TechnologyKamlesh @ 11:28 pm

I have been using Laptop since few months and most of the time I get into trouble by pressing wrong combination of keys.  I am an expert PC keyboard user, but I am still not that fast on a Laptop keyboard.  Today, while updating my Project Status Report in Microsoft Excel 2010, I pressed a secret combination of keys which showed me the below screen:

Excel shows Formula instead of Values

For a moment, I got shocked! Microsoft Excel showed Formula’s instead of the values.  The Date column (Column B) showed me the internal numeric values too. I realized that I must have pressed a combination of reserved keys in Excel.  I could resolve this by pressing CTRL+` key.  Please note that in most of the keyboards, the ` key is located left to the numeric 1 (and below Escape key). As an alternate for Mouse users, you can even use the Office ribbon (Formula’s tab) to access the same option:

Excel 2010 Show Formula's toolbar

For the Keyboard Users, please refer to the complete list of Excel 2010 keyboard shortcuts on the Microsoft website.

 


Jan 01 2012

Wish you a Happy and Prosperous New Year 2012

Category: EventsKamlesh @ 7:54 am
Wish you a Happy and Prosperous New Year 2012

Wish you a Happy and Prosperous New Year 2012