password protection workbook

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password protection for workbook

Password protection for workbook

resolvedResolved · High Priority · Version 2010

Nan has attended:
Excel Intermediate course
Excel Advanced course

Password protection for workbook

Hi,

I have a documents at work, other colleague has put 2 layers of passwords to proect the workbook when you opens up the excel workbook. How do I change the second password on version 2010? or even remove the second password?

Many thanks

RE: Password protection for workbook

Hi Nam

If you know the passwords then you can change or remove them as follows -

1. Open the file entering the passwords
2. Select File, Save As.
3. Click Tools, General Option at botton left.
4. Change the second level 'Password to modify' or remove the black circles.
5. Click Save.

Hope that helps. More difficult if you don't know the passwords.

Regards
Doug Dunn
Best STL

Tue 8 Nov 2011: Automatically marked as resolved.


 

Excel articles

Please browse our web site to find out more about
excel in courses and other training courses.

Excel tip:

Convert Text to Columns in Excel 2010

If you have a cell in your Excel spreadsheet that contains a lot of text and you want to divide it into separate columns, this can only be done if there is a logical character which separates the text, for example, a comma.

Select the cells you would like to convert. On the Data tab, click Text to Columns. Choose the format of your current data.

Select Delimited if the text contains a logical character otherwise select Fixed Width if there are a certain number of spaces between each field.

Click Next when a preview of the data appears. Then select the type of character that separates the various fields. If the character is not listed, select Other and enter the character.

Click Next again and then choose the format for each of the columns. Select the column heading in the Data preview and then select a data type from the Column data format options.

Click Finish and the text will appear in several columns.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.