Logo
HOW TO
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
 
 
Windows 7

Microsoft Excel 2010 : Protecting and Securing a Workbook - Adding Password Protection to a Workbook

5/27/2014 1:04:43 AM
You can assign a password and other security options so that only those who know the password can open the workbook, or to protect the integrity of your workbook as it moves from person to person. At times, you will want the information to be used but not changed; at other times, you will want only specific people to be able to view the workbook. Setting a workbook as read-only is useful when you want a workbook, such as a company-wide bulletin, to be distributed and read, but not changed. Password protection takes effect the next time you open the workbook.

Add Password Protection to a Workbook

1. Open the workbook you want to protect.

2. Click the File tab, and then click Save As.

3. Click Tools, and then click General Options.

4. Type a password in the Password to open box or the Password to modify box.

Important

It’s critical that you remember your password. If you forget your password, Microsoft can’t retrieve it.

5. Select or clear the Remove automatically created personal information from this file on save check box.

6. To set macro security options in the Trust center, click Macro Security.

7. Click OK.

8. Type your password again.

9. Click OK.

10. If you entered passwords for Open and Modify, type your password again, and then click OK.

11. Click Save, and then click Yes to replace existing workbook.

For Your Information: Using a Strong Password

Hackers identify passwords as strong or weak. A strong password is a combination of uppercase and lowercase letters, numbers, and symbols, such as Grea8t!, while a weak one doesn’t use different character types, such as Hannah1. Be sure to write down your passwords and place them in a secure location.


Open a Workbook with Password Protection

1. Click the File tab, click Open, navigate to a workbook with password protection, and then click Open.

2. Click Read Only if you do not wish to modify the workbook, or type the password in the Password dialog box.

3. Click OK.

Change or Remove the Password Protection

1. Click the File tab, click Open, navigate to a workbook with password protection, and then click Open.

2. Type the password in the Password dialog box.

3. Click OK.

4. Click the File tab, click Save As, click Tools, and then click General Options.

5. Select the contents in the Password to modify box or the Password to open box, and then choose the option you want:

  • Change password. Type a new password, click OK, and then retype your password.

  • Delete password. Press Delete.

6. Click OK.

7. Click Save, and then click Yes to replace existing workbook.
Other -----------------
- Microsoft Excel 2010 : Protecting and Securing a Workbook - Adding Security Encryption to a Workbook
- Microsoft Excel 2010 : Protecting and Securing a Workbook - Locking or Unlocking Worksheet Cells
- Microsoft Excel 2010 : Protecting and Securing a Workbook - Protecting a Worksheet - Apply a Password to a Worksheet
- Microsoft Excel 2010 : Protecting and Securing a Workbook - Inspecting Workbooks
- Working in the Background : WORKING WITH THE NETWORK LIST MANAGER
- Working in the Background : IMPLEMENTING APPLICATION RESTART AND RECOVERY
- Working in the Background : PROVIDING POWER MANAGEMENT (part 2) - Detecting a Change in Monitor State
- Working in the Background : PROVIDING POWER MANAGEMENT (part 1) - Getting the Power Management State
- Automating Windows 7 Installation : Customizing Images Using Deployment Image Servicing and Management (part 3) - Servicing the Operating System in an Image , Committing an Image
- Automating Windows 7 Installation : Customizing Images Using Deployment Image Servicing and Management (part 2) - Mounting an Image , Servicing Drivers in an Image
 
 
REVIEW
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
 
VIDEO TUTORIAL
- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 1)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 2)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
 
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
Top 10
- Microsoft Excel : How to Use the VLookUp Function
- Fix and Tweak Graphics and Video (part 3) : How to Fix : My Screen Is Sluggish - Adjust Hardware Acceleration
- Fix and Tweak Graphics and Video (part 2) : How to Fix : Text on My Screen Is Too Small
- Fix and Tweak Graphics and Video (part 1) : How to Fix : Adjust the Resolution
- Windows Phone 8 Apps : Camera (part 4) - Adjusting Video Settings, Using the Video Light
- Windows Phone 8 Apps : Camera (part 3) - Using the Front Camera, Activating Video Mode
- Windows Phone 8 Apps : Camera (part 2) - Controlling the Camera’s Flash, Changing the Camera’s Behavior with Lenses
- Windows Phone 8 Apps : Camera (part 1) - Adjusting Photo Settings
- MDT's Client Wizard : Package Properties
- MDT's Client Wizard : Driver Properties
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro