Ravi Shankar

Tweaking Apps

Protect

How to enable auto filter for protected sheet in Excel

By 9 Comments

We had already seen the following tutorials related with protection of worksheet in Excel 2016, 2013 & 2010.

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

Review menu - Protect Sheet

Info Menu

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

Info Menu - Protect Sheet

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

Protect Sheet Excel 2010

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.

Protected Sheet with auto filter

Hide worksheet formula in Excel 2013 & Excel 2010

By 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.

image

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.

image

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

image

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

image

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.

image

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

Password protection in PowerPoint 2013 and PowerPoint 2010

By Leave a Comment

PasswordProtect

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.

Protect Presentation

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

Encrypt with Password

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

Encrypt Document

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

Confirm Password

A password protected presentation will be highlighted as shown below.

Permissions PowerPoint 2010

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.

PowerPoint 2010 General Options

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.

General Options

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.

Clear Password

How to password protect workbook in Excel Mac 2011

By 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.

201109292051.jpg

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

201109292054.jpg

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.