How to portect excel workbook all cells

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
ARTICLESHIP 24 August 2026
Article Assistant

M/s.S.G.Salecha & Co.

Mumbai

CA Inter

View Details
Company
19 August 2026
Chartered Accountant - Financial Consolidation & Reporting

Synergy Keystone

Mumbai

CA

View Details
Company
ARTICLESHIP 14 August 2026
Article Assistant

N J Suresh & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 25 August 2026
CA Article's

Saini Pati Shah & Co LLP

Mumbai

CA Inter

View Details
Company
11 August 2026
COMPLIANCE EXECUTIVE

YMW COMPLIANCE SERVICES LLP

Others

CA Final

View Details
Company
ARTICLESHIP 26 August 2026
CA Article Assistant/CA Drop Out/Accounts Executive

PARV & Co.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
24 August 2026
Semi-Qualified CA/CA Finalist - Tax, GST, Audit & Accounts

Bharat Shah & Associates

Mumbai

CA Inter

View Details