How to Lock a Cell Reference in Excel: F4, $ and Mixed References
Lock a cell in an Excel formula with $, toggle it with F4 or Cmd+T on a Mac, and know when to use $A$1, A$1 or $A1.
· 4 min
Clear how-to guides, plain explanations and sourced news on the software, devices and cars you use.
Lock a cell in an Excel formula with $, toggle it with F4 or Cmd+T on a Mac, and know when to use $A$1, A$1 or $A1.
· 4 min
· 3 min
· 3 min
Do the thing, step by step.
105 articles →
Finally understand how it works.
66 articles →
What to buy, and what to skip.
57 articles →
What changed, with the sources.
75 articles →
Useful today, still useful next year.
· 2 min
· 3 min
· 6 min
· 3 min
· 4 min
· 2 min
· 3 min
· 2 min
· 4 min
· 4 min
Software
Paste formula results as plain values in Excel on Mac or Windows, choose which values option keeps number formatting, and find Skip Blanks in Paste Special.
Check a smart plug's amp rating first, compare it with your appliance, and read the heater manual before plugging in anything that makes heat. Features like Matter come second.
Use Excel's Data > Text to Columns wizard to split one column into several, and set the Destination so results land where you want.
Cloud & Productivity Software
Stop Excel stripping zeros from zip codes and turning long numbers into E+15, with a custom format, a Power Query Text column, or one setting.
Cloud & Productivity Software
Suggest changes in Google Docs without touching the original text, then accept or reject them one at a time or all at once from the Tools menu.
Google has retired the Sparkline chart type in Sheets. Here is what Google confirms, what happens to old charts, and what to use instead.
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.
Privacy & Security
What Android's Advanced Protection switch turns on, what stops working, how the 3-hour pause works, and how it differs from Google's account program.
Add checkboxes in Google Sheets on desktop or Android, and on a computer make them return Yes/No instead of TRUE/FALSE.
Before buying a smart thermostat, confirm your wiring with a compatibility checker, then check what the ENERGY STAR label requires.
Wi-Fi 7's big features, MLO and 320 MHz channels, only help when your phone or laptop supports them as well as the router. Here is what to check.
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.
Written with AI from pages read on the web that day, not from memory.
Sources sit next to the facts they support, one click away.
Links and claims are tested automatically. Failures do not go live.