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%
4%
3%
0%
Reviews
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
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.