How to portect excel workbook all cells

860 views 1 replies

Follow the very simple method:

 

Open an excel file

select all cells press Ctrl + A

Right click on selected cells

select format cells

go to protection check locked if unchecked

press ok

go to review tab

click protect sheet

Click on any option which you want user to be able to do like allow user to select cells etc....

enter password

click ok

reenter password

 

_____________________________________

 

 

thats it....

 

Replies (1)

How to Unlock The protected Sheet, Without Knowing Password, Is There any Other way or we cant open????

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
29 June 2026
ACCOUNTANT

SANDEEP AASHISH & CO

Araria

B.Com

View Details
Company
25 June 2026
Accounts & Taxation Executive

Dindukurthy & Associates

Hyderabad

MBA

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Article Assistant or Paid Assistant

VIKAS VERMA & CO

New Delhi

Others

View Details
Company
ARTICLESHIP 30 June 2026
Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details