Microsoft Excel

Protect a worksheet range in Excel

Chris Menard

13 Feb 2017 — 1 min read

To protect a worksheet

1. Select the cells you want to users to change. 2. On the Home tab, in the Alignment group, choose the small arrow to open the Format Cells dialog box or right click and select Format Cells. 3. The Format Cells dialog box launcher opens. On the Protection tab, uncheck Locked check box, and then click OK. 4. On the Review tab in the ribbon, in the Changes group, select either Protect Sheet and click OK.

Video on protecting a worksheet

At 1:50 in the video is a cool trick on selecting the constant cells and unlocking them before protecting the worksheet.

Protect cell ranges in Microsoft Excel by Chris Menard

**Helpful Link:**

[https://support.office.com/en-us/article/Lock-cells-to-protect-them-in-Excel-2016-for-Windows-cb7835f6-9c37-4161-bb53-d1c410acaf21](https://support.office.com/en-us/article/Lock-cells-to-protect-them-in-Excel-2016-for-Windows-cb7835f6-9c37-4161-bb53-d1c410acaf21|

Microsoft Teams: Save Chat and Channel Messages is Back!

How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.

Master Microsoft Teams Follow Threads to Boost Your Productivity

As a Microsoft MVP and certified trainer, I’m always excited to share the latest productivity tools that help you work smarter. If you’re a frequent Microsoft Teams user, you’ll be thrilled to hear about the new Teams Follow Threads feature rolling out in public preview as of

Summarize Outlook Attachments with Copilot

Managing emails efficiently is crucial, especially when it comes to handling attachments. I demonstrate an exciting new feature that has rolled out in Microsoft Outlook’s Copilot — the ability to summarize Outlook attachments with Copilot. While Copilot has long been capable of summarizing email bodies, this new enhancement now extends