How to turn off auto calculation in Excel

In this tutorial, we will see how to disable auto calculation in Excel 2016, 2013 & 2010. Auto calculation in Excel is an useful feature which would automatically recalculate results based on the changes to the input values. But if you want to temporarily disable this option then you can use the settings available as […]

Hide worksheet formula in Excel 2013 & Excel 2010

Excel 2013 and Excel 2010 allow users to hide formula used in a Worksheet. You can use this feature when you want to prevent any one from accidentally changing the entered formula. Let us say you want to hide the formula (=SUM(F5:F8)) which has been used in the bellow example. Select the cell where the […]

How to unhide comments in Excel

Excel 2013 and Excel 2010 generally shows comments in worksheet with the Indicator as shown below. And when you hover over the indicator it will display the added comments. But in case if you are not able see the comments added to your worksheet then try the unhide option available as part of the Click […]

How to Insert, Delete, Customize Comments in Excel

This tutorial provides information on the comment feature available in Excel 2013 & Excel 2010. The following will be covered as part of this tutorial. How to insert comment Customize the comment box Navigate between Comments Delete Comment How to insert comment Excel allows users to insert comment using the options available as part of […]

How to recover a workbook in Excel 2013 and Excel 2010

This tutorial explains the auto recover feature available in Excel 2013 and Excel 2010. The auto recover feature regularly takes a backup of the workbook and stores it in a pre defined location. This feature is useful if Excel suddenly crashes and you want to recover the working copy. Document Recovery A document recovery pane […]

Change the default file location in Excel 2013 and Excel 2010

We have already seen the following articles on Microsoft Word 2010 and Microsoft PowerPoint 2010. How to change default file location in Word 2010. How to change default file location in PowerPoint 2010. In this tutorial we are going to see how to change the default file location in Microsoft Excel 2013 and Excel 2010. […]