How to Split Cells in Excel (Text to Columns & Flash Fill)
Split cell contents in Excel with Text to Columns, Flash Fill or TEXTSPLIT — without overwriting the column beside it or losing your leading zeros.
How-To Guides
Step-by-step guides for the software and systems people actually use at work.
How to Make a Graph in Excel (And Pick the Right Type)
Make a graph in Excel, choose the chart type that fits your question, avoid misleading axes and pie charts, and build charts that update themselves.
How to Sort in Excel Without Scrambling Your Data
Sort data in Excel safely, sort by multiple columns and custom orders, and fix sorting that is greyed out or puts numbers in the wrong order.
How to Add a Drop Down List in Excel That Updates Itself
Add a drop-down list in Excel with Data Validation, make it update itself from a Table, build dependent lists, and fix a dropdown that stopped working.
How to Use VLOOKUP in Excel (And Why It Returns #N/A)
Use VLOOKUP in Excel with exact match, understand why it only looks right, fix #N/A errors, and know when XLOOKUP or INDEX MATCH is the better choice.
How to Unhide Columns in Excel (Including Column A)
Unhide columns in Excel, reveal column A when the normal method fails, and fix the cases where Unhide does nothing because they were never hidden.
How to Merge Cells in Excel (And Why You Usually Shouldn’t)
Merge cells in Excel, see what merging breaks in sorting and pivots, and use Center Across Selection for the same look without the problems.
How to Remove Duplicates in Excel (Without Losing Data)
Remove duplicates in Excel, choose which columns define a match, find them safely first with UNIQUE or COUNTIF, and fix duplicates Excel cannot see.
How to Disable Startup Programs (All 4 Places They Hide)
Disable startup programs in Windows using Task Manager, the Startup folder, Task Scheduler and Services — and stop apps that re-enable themselves.
How to Speed Up Your Computer (Diagnose It First)
Find out why your Windows PC is slow using Task Manager, then apply the fix that matches the real bottleneck — memory, disk, startup or one bad process.