To select all of the cells on the sheet, use the keyboard shortcut Ctrl + A. Format cells by right-clicking. Uncheck the Locked option on the Protection tab and click Ok. Select only the cells, columns, or rows that you want to keep safe.
Firstly, open your Excel worksheet.
After that, select "Review."
Finally, select "Protect Workbook."
Enter a password of your choice now.
Finally, select "OK."
To enter the Format Cells dialogue box, select the cells you want to safeguard their formatting but only allow data entry in, then hit Ctrl + 1 at the same time.
Uncheck the Locked box under the Protection tab in the Format Cells dialogue box, then click the OK button.
Learner's Ratings
4.7
Overall Rating
83%
10%
5%
2%
0%
Reviews
M
MD Yasin Khan
5
very helpfully for me thanke you learn vern team member
A
Abrar Hossen
5
I am happy for this course ....love you...I want to more course in bangla tutorial...from Bangladesh
M
Md Masud Rana
5
Good job
A
AB Nazim
5
good
I
Ibrahim Khalil
5
Very good
S
Sathi Nanda
5
Very good teaching quality
S
Soibol Debnath
5
It a very good course.
S
syed enterprise
5
thank you dear
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
Share a personalized message with your friends.