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.6
Overall Rating
81%
11%
5%
3%
0%
Reviews
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.