How to Remove Blank Rows in Excel
The most widely repeated method for this quietly destroys rows full of real data. Here is why, and what to use instead.
Productivity articles
Tips, systems and tools to get more done with less friction.
How to Merge Cells in Google Sheets
Only the top-left value survives, and merged cells break sorting. Both worth knowing before you click the button.
How to Highlight Duplicates in Google Sheets
The dollar signs are the whole trick. Without them the range shifts and most duplicates go unhighlighted.
Why Your Excel Formula Is Not Calculating
Four causes, and you can tell them apart in seconds. Check the two workbook-wide settings before inspecting any cell.
Excel Dates Not Recognised as Dates
Real dates align right, text aligns left. That one glance tells you which problem you have before you change anything.
Why VLOOKUP Cannot Find a Match That Exists
Test with =A2=D2 first. FALSE means a data problem, TRUE means a formula problem, and they need completely different fixes.
Why Your Excel File Is Slow and Large
The first fix routinely takes a workbook from 40 MB to under 2 MB in a couple of minutes.
Google Sheets Formulas Not Updating
There is no manual mode and no F9, so if you arrived from Excel advice the usual fix does not exist here.
How to Get Backlinks
The least satisfying area of SEO, because the honest advice is slow and cannot be automated. That is exactly why it still works.