banner_ad

How to portect excel workbook all cells

Others 850 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????


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
14 May 2026
Senior Accounts Executive

Karan Gupta & Co.

New Delhi

Graduate (Any)

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details
Company
07 June 2026
Tax Associate

Rajkumar Jain & Co.

Ahmedabad

Graduate (Any)

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
26 May 2026
Audit executive

vdsr & co LLP

Chennai

CA Inter

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details