How to enable auto filter for protected sheet in Excel
We had already seen the following tutorials related with protection of worksheet in Excel 2016, 2013 & 2010. Prevent users from adding new worksheet. Password Protect Worksheet in Excel. Unprotect Worksheet in Excel. And if a worksheet with auto filter is protected then users will not be able to use auto filter unless it is […]
How to change worksheet theme in Excel
In this short tutorial we will be seeing how to change theme of worksheet in Excel 2016, Excel 2013 & Excel 2010. You can change the theme using the option available as part of the Page Layout menu. Navigate to Page Layout and click the Themes menu option under Themes section. The themes option allows […]
Block emails based on subject in Outlook 2016, 2013 & 2010
This post is reply to a query asked by a Digital Answers reader <Thanks Brian> Please tell me how to block a persistent group of junk mail senders. I have tried by “blocking sender” over 400 times without success. I get 10 t0 25 emails daily promoting “Viagra” and they keep changing the senders name […]
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 […]