How to protect/lock a row of formulas without protecting the Worksheet

[Manny74]

Hello, I want my team to enter # of Clients with Appointments & Kept Appointments.
But I don't want them to accidently type over my formulas in row 14 (Total....B,C & D)
I would like to lock/protect row 14 only, without having to protect the sheet or workbook.....
Is this possible? If so, how do I do this?

	A	B	C	D
1		# of Clients with Appointments	Kept Appointments	No Shows
2	Jul	35	30	5
3	Aug	35	32	3
4	Sep	35	29	6
5	Oct	35	29	6
6	Nov	35	28	7
7	Dec	35	32	3
8	Jan	35	31	4
9	Feb	35	33	2
10	Mar	35	35	0
11	Apr	35	35	0
12	May	35	35	0
13	Jun	35	31	4
14	Total	420	380	40

 

[Logit]

How To Protect Cells In Excel Without Protecting The Sheet | SpreadCheaters

You can watch a video tutorial here.

spreadcheaters.com

Uncheck : " In Cell Drop Down"

Place cursor in " Source " ... left click " Row 14 " ... click OK.

 

[Manny74]

How To Protect Cells In Excel Without Protecting The Sheet | SpreadCheaters

You can watch a video tutorial here.

spreadcheaters.com

Uncheck : " In Cell Drop Down"

Place cursor in " Source " ... left click " Row 14 " ... click OK.

I read the article, and this worked, thank you so much!!!

 

[Logit]

Your are welcome.

 

[Peter_SSs]

It might not be an issue for you but just be aware that if your team decide to paste or drag something into the cell rather than just typing then the Data validation will be defeated.

BTW, what is the problem with protecting the worksheet if the whole sheet except for row 14 is unlocked?