Wednesday 9 September 2015

Excel Tips - Tip 21 (Show all Formulaes)

Hello Everyone,

Here is the Twenty First Tip for you.

Today's excel tip is about displaying formulas in excel.

All of you know that you can display a formula by pressing F2 in the relevant cell or you can view the formula in the formula bar.

But what if you want all the formulas to be displayed at once.

I mean all the formulas in the workbook.........

You can do this by pressing Ctrl and `.

To restore press the same combination again

Note - ` key is usually found on the key to the left of number 1.

Hope, this tip is clear with my explanation.

In case of any doubt, please feel free to contact me any time.

If any of your friends is also interested for the said excel Tips, then asked them to fill the form by clicking on the below mentioned link:


If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal
Excel Enthusiast

 +91-9045773456



No comments:

Post a Comment