word-excel-access-help.com logo
Excel Password
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Excel Password
Additional Resources

Excel Password

Excel Password | Microsoft Excel XP | Page 2

Microsoft Excel XP logo
Learn step-by-step how to add an Excel Password to a worksheet or workbook. You may have added a password for good reason, you can also remove it!

You can require a password to open a file to prevent unauthorized users from opening a workbook at all.

You can also require a password to modify a file to allow others to open the workbook but only allow authorized users to make changes to it. If someone changes the workbook without the password to modify, that person can save the workbook only by giving it a different file name.

Excel Office Helper What's on this page...
Protect Worksheet Elements
Protect Workbook Elements
Protect a Workbook file from viewing or editing

See Also...
Change a password or protection
Remove a password or protection

Protect Workbook Elements

You can also protect the specific elements of an entire workbook file. For example, protecting the structure of the workbook so that worksheets in the workbook can't be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be inserted.

To protect workbook elements, follow these steps:

1. Choose ToolsProtectionProtect Workbook from the menu bar.
  Excel Password: Protect Workbook dialog box
2. Select the Structure check box,

to protect the structure of a workbook so that worksheets in the workbook can't be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be inserted.

Select the Windows check box,

to protect windows so that they are the same size and position each time the workbook is opened.

Type a password in the "Password" box.
3. Click OK.
  Excel Password: Confirm Password dialog box
4. Re-type the same password in the "Reenter password to proceed" box.
5. Click OK.
See also... Change a Password | Remove a Password
Protect Worksheet Elements
Protect Workbook File from View or Edit
Back to Top
Return to Excel XP from Excel Password
Excel XP Topics
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter