Protect

How to enable auto filter for protected sheet in Excel

October 10, 2015 By Ravi Shankar 11 Comments

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 enabled while protecting the worksheet. This tutorial is about the steps required for enabling auto filter for a protected worksheet in Excel 2010.

Click the Protect Sheet option available under Review menu or Info menu.

Review Menu

Click Review menu –> Changes –> Protect Sheet

Info Menu

Click File menu –> Info menu –> Protect Workbook –> Protect Current Sheet.

On clicking the Protect Sheet option would display the following Protect Sheet window.

Scroll down the “Allow all users of this worksheet to” list and make sure to tick the check box with caption as “Use AutoFilter”. Click OK button to confirm and save the changes.

Now excel users will be able to use the auto filter option even in a protected worksheet.

Hide worksheet formula in Excel 2013 & Excel 2010

July 26, 2015 By Ravi Shankar Leave a Comment

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 formula has been entered and navigate to Format menu and click the Format Cell menu option (You can also right click and select Format Cell in the Context menu).

In the Format Cell window, navigate to Protection tab and tick the checkbox with Label as Hidden. Click the Ok button to save the changes.

Then right click on the Sheet and select Protect Sheet from the list of available menu option.

In the Protect Sheet window, tick the check box with label as Protect worksheet and contents of locked cells.

If you want to just hide formula then it is not needed to password protect the sheet. Click Ok button to save the changes.

Now when you navigate to the Formula Cell, the formula bar will not displayed any information.

Bu this you can prevent excel users from seeing formula used in the worksheet.

Password protection in PowerPoint 2013 and PowerPoint 2010

May 29, 2015 By Ravi Shankar Leave a Comment

The tutorial explains the different ways to password protect a presentation file in PowerPoint 2013 and PowerPoint 2010. You can password protect a presentation in PowerPoint 2013 and PowerPoint 2010 by the following ways

1. Using Info Menu

Click File menu followed by Info and then navigate to Permission section.

Click the down arrow available below the Protect Presentation option and select Encrypt with Password from the drop down list.

This would display the following Encrypt Document window. Enter the password for protecting the file and click OK to save the changes.

Repeat the same as Encrypt Document window for the Confirm Password window as well.

A password protected presentation will be highlighted as shown below.

2. Using File –> Save As

The other alternate way to protect a presentation file is to use the General Options same as password protection of a PowerPoint 2007 presentation. Click the File mu then the Save As option. In the Save As dialog box, select General Options available as part of tools drop down list.

Using the General Options, you can set password to open as well as password to modify a PowerPoint presentation file. After entering the required details, click OK to confirm and save the changes.

To remove password protection for a presentation, Navigate to Protect Presentation section as discussed earlier and select the Encrypt Password from the list. Now clear the password that was already set for the Presentation then click OK to confirm the changes.

How to password protect workbook in Excel Mac 2011

September 29, 2011 By Ravi Shankar Leave a Comment

Excel for Mac 2011 users can password protect the workbook using the option provided as part of the File menu. Click the File menu and select Passwords from the displayed menu list.

This would display the following File Passwords window with different password option.

You can set a password for opening the excel workbook using the Password to open field. Similarly to set a password for modifying the content in the excel workbook, you can use the Password to modify. If you want to make the workbook as readonly then mark the check box labelled as Read-only recommended.