How to Unlock Cells in Excel & Google Sheets Guide

Why Unlocking Cells Becomes a Hidden Time Sink

If you run a business, agency, or sales team, your spreadsheets aren’t just files—they’re living systems. Forecast models, media plans, commission trackers, client reports. Very quickly, you end up with dozens of Excel and Google Sheets workbooks where certain cells must stay locked (formulas, KPIs), while others need to be editable for the team.

The problem: every small change—"unlock this column for a client", "let the SDRs edit only these rows"—costs you minutes of careful clicking. Multiply that by every campaign, every quarter, every new hire.

Let’s break down how to unlock cells manually first (so you understand exactly what’s happening), then look at how an AI computer agent can take over 90% of this work.

Manual Method 1: Unlock All Cells in Excel (Fast Reset)

Use this when a sheet is locked and you just want everything editable again.

1. Open your workbook and go to the protected sheet.
2. On the Review tab, click Unprotect Sheet.
3. If prompted, enter the password and press OK.

At this point the sheet is editable, but cells may still be marked as Locked internally. If you want a clean slate:

1. Press Ctrl + A to select the whole sheet.
2. Press Ctrl + 1 to open Format Cells.
3. Go to the Protection tab.
4. Uncheck Locked, click OK.

Now, if you protect the sheet again, nothing will be locked unless you explicitly lock it.

Pros:

• Very fast when you just need everything open.
• Easy to explain to teammates.

Cons:

• Not safe for shared or client-facing files.
• Easy to accidentally expose formulas or sensitive logic.

Manual Method 2: Unlock Only Certain Cells in Excel

This is for templates where you want some cells editable and the rest protected.

1. First, unlock everything:
   • Press Ctrl + A.
   • Press Ctrl + 1 > Protection tab.
   • Uncheck Locked > OK.
2. Select the cells you want to keep protected (for example, formula columns or headers).
   • Select a range with your mouse.
   • Use Ctrl + click for non-adjacent ranges.
3. Mark them as locked:
   • With those cells selected, press Ctrl + 1.
   • On Protection, check Locked > OK.
4. Protect the sheet:
   • Go to Review > Protect Sheet….
   • Choose a password (optional but recommended).
   • In the list of options, decide whether users can select locked cells, format, insert rows, etc.
   • Click OK.

Now only the ranges you marked as locked are protected. To unlock them later, either:

• Unprotect the sheet fully (Review > Unprotect Sheet…), or
• Use Allow Users to Edit Ranges to give controlled access to specific cells.

Pros:

• Fine-grained control over which cells stay safe.
• Great for internal templates and reports.

Cons:

• Tedious when you have many small ranges.
• Repeating this for every workbook is pure administrative drag.

Manual Method 3: Unlocking Cells in Google Sheets

Google Sheets handles protection via protected ranges.

To unlock everything on a sheet:

1. Open the sheet and go to Data > Protect sheets and ranges.
2. In the sidebar, you’ll see any protected ranges or whole-sheet protections.
3. Click each protected range.
4. Either remove the protection (trash icon) or adjust Permissions so more users can edit.

To keep structure but unlock specific areas:

1. Select the range you want editable (e.g. B2:B100).
2. Go to Data > Protect sheets and ranges.
3. Click the existing rule that covers this range.
4. Edit the range or permissions so collaborators can edit only what you specify.

Pros:

• Clear, visual list of all protections.
• Easy to tweak access per user or role.

Cons:

• Still manual and repetitive across many files.
• Easy to forget a hidden protected range and confuse collaborators.

Automated Method: Use an AI Computer Agent

Manual is fine when you own a single spreadsheet. It breaks when you:

• Clone the same quote or proposal template for every client.
• Run weekly Google Sheets dashboards per campaign.
• Maintain a fleet of Excel trackers across teams and regions.

An AI computer agent, like Simular’s desktop agent, can:

1. Understand your rules: “In any ‘Quote_*.xlsx’ file, unlock the input rows, keep formula columns protected, and give sales managers full access.”
2. Navigate like a human: open Excel or Google Sheets in the browser, hit the right menu items (Review, Data > Protect sheets and ranges), and apply your rules.
3. Repeat at scale: run this on 10, 100, or 1,000 files without getting bored or making copy-paste mistakes.

You design the workflow once; the agent executes it thousands of times.

Pros:

• Massive time savings across large workbooks or file libraries.
• Consistent, auditable protection policies.
• Frees you from being the “spreadsheet gatekeeper.”

Cons:

• Requires a bit of upfront thinking about your rules.
• Best for organizations comfortable trusting an agent with file operations.

Hybrid Approach: You Design, the Agent Does the Clicking

The sweet spot for most teams is hybrid:

• You decide which cells should ever be editable (inputs, comments, notes).
• You teach an AI agent the pattern once.
• Anytime a new workbook, template, or client sheet is created, you hand it to the agent.

The agent:

• Unprotects the sheet if needed.
• Applies locked/unlocked settings exactly as you specified.
• Documents what changed so you stay in control.

Result: your spreadsheets stay structured and safe, your team edits confidently, and you get your hours back for strategy instead of protection menus.