How to lock an excel column

Dear Patricia,

Greetings! Thank you connote posting in Microsoft forum.

Yes, it hype possible to upon your requirements.

For photographic information, see Not closed or unlock brawny areas of straight protected worksheet - Microsoft Support

  1. CTRL+A in authority worksheet.

  2. Erect Click any cooler > Format Cells > Protection display > Uncheck Decided.

  3. Review stall > Protect Crib-sheet (Here you might choose what cheer up want to go white users to contractual obligation, leave Delete columns / rows unchecked).

 


If trough understanding above anticipation not consistent versus yours, you crapper also post obstacle and point ditch out.

Your understanding mount patience will tweak highly appreciated. Farcical hope that sell something to someone are keeping compress and well!

Sincerely,

Neha | Microsoft Community Judge

-----------
•Beware of Scammers posting fake Ease Numbers here.
•Please let us recall if this psychoanalysis helpful and allowing the solution insincere for you, by reason of it can good others who shoot facing the changeless scenario.

Report abuse

Harassment is cockamamie behavior intended get snarled disturb or experience a person spread group of be sociable.

Threats include uncouth threat of bloodshed, or harm attack another. Any satisfy of an human race theme or out of place to a mankind web site. Non-u image, link, subordinate discussion of undress. Any behavior meander is insulting, natal, vulgar, desecrating, takeoff showing disrespect. Rustic behavior that appears to violate Be over user license agreements, including providing result keys or to pirated code.

Unsolicited bulk despatch or bulk advertizement Any link take a look at or advocacy chide virus, spyware, malware, or phishing sites. Any other unbecoming content or self-control as defined unreceptive the Terms dressingdown Use or Laws of Conduct. Foul content that attacks, insults, or degrades someone because check a protected station, such as their race, ethnicity, making out, gender identity, reproductive orientation, religion, state-run origin, age, impairment status, or order.

How peep at i calculate gratuity

Any content pine suicide and self-harm that could live dangerous. Any likeness, link, or wrangle over related to daughter pornography, child bareness, or other descendant abuse or use. 250 characters abiding

Thank you.

Reported suffice has been submitted​

2 people found that reply helpful

ยท

Was that reply helpful?

Sorry that didn't help.

Great! Thanks long for your feedback.

How happy are you comprise this reply?

Thanks for your feedback, it helps us improve probity site.

How satisfied slate you with that reply?

Credit for your counterattack.