• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips

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

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

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016 Tagged With: auto filter, Enable, Excel 2010, Protect, 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.

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.

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: Excel 2010, Format Cell, Formula, Hidden, hide, Protect, Worksheet

Password protection in PowerPoint 2013 and PowerPoint 2010

May 29, 2015 By Ravi Shankar 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

Filed Under: Office 2010, PowerPoint 2010 Tagged With: Document, Encrypt, File, Password, Powerpoint 2010, presentation, Protect

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.

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.

Filed Under: Excel, Mac, Technical Tagged With: excel 2011, Mac, Password, Protect, Workbook

Primary Sidebar

TwitterLinkedin

Recent Posts

  • How to set preferred Wifi network on Mac
  • Attribute Unavailable: Estimated section warning before iOS 11.0
  • How to recover Firefox password from Time Machine backup
  • Show hidden files and folders on Mac
  • How to request a refund for apps in App Store

Pages

  • About
  • Privacy Policy
  • Terms and Conditions

Copyright 2022 © rshankar.com

Terms and Conditions - Privacy Policy