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
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER

Anupam Parashar & Co.

Ghaziabad

CA Final

View Details
Company
19 September 2026
CA/Semi-CA/BCom

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
26 September 2026
Chartared Accountant

pushpganga ventures

Pune

CA

View Details
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
ARTICLESHIP 07 September 2026
CA Articles

Kothari Jain Patil & Chartered Accountants

Pune

CA Inter

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details
Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details