Cloud & Productivity Software
How to Lock Only Some Cells in Excel (Unlock Inputs, Then Protect)
Unlock the input cells, lock the formula cells, then protect the sheet so others can type in Excel without breaking your formulas.
Covers cloud productivity suites, collaboration platforms, storage services, and SaaS tools including Microsoft 365, Google Workspace, and similar enterprise and SMB solutions.
30 articles
Cloud & Productivity Software
Unlock the input cells, lock the formula cells, then protect the sheet so others can type in Excel without breaking your formulas.
Cloud & Productivity Software
Flip rows to columns in Excel for Mac with Paste > Transpose, and learn why Cut fails and why Transpose is greyed out for tables.
Cloud & Productivity Software
Combine INDEX and MATCH to look up a value in any column, force an exact match with 0, and fix the #N/A and #REF! errors.
Cloud & Productivity Software
Learn how to tell which cause is behind Excel's #SPILL! error, whether it's a blocked range, a volatile size or a whole-column lookup, and how to fix each.
Cloud & Productivity Software
Add in-cell checkboxes with Insert > Checkbox in Excel for Microsoft 365, read their TRUE/FALSE values in formulas, and remove them properly.
Cloud & Productivity Software
Wrap any Excel formula in IFERROR so it shows your own message or value instead of an error, and know what that hides.
Cloud & Productivity Software
Fix numbers stored as text in Excel with Convert to Number, turn the green triangle back on, or use VALUE and paste the results back.
Cloud & Productivity Software
Print a wide Excel sheet on one page or one page wide with Scale to Fit, read the Scale box for legibility, and fix Fit to when it seems broken.
Cloud & Productivity Software
Build an Excel PivotTable with Insert > PivotTable, place it where you want, and fix a field that shows a COUNT instead of a SUM.
Cloud & Productivity Software
Use Excel's Flash Fill (Ctrl+E) to split or combine names, turn it on if it won't preview, and switch to formulas when your data changes.
Cloud & Productivity Software
Freeze header rows and columns in Excel on Windows, Mac, iPad and iPhone, pick the right cell first, and fix a grayed-out Freeze Panes button on a Mac.
Cloud & Productivity Software
Add page numbers and a Page X of Y count in Google Docs, skip the first page, start later, and fix options that vanish in pageless format.