Short answer: pick a guide below. Each one walks through an Excel task from start to finish — the exact clicks, what to do when it doesn't work, and answers to the follow-up questions people ask most.
All guides
How to Remove Duplicates in Excel
Find them, highlight them, delete them — and what "Remove Duplicates" keeps (the first one) that most guides never mention. October 2026.
How to Create a Drop-Down List in Excel
Data Validation lists from typed items or a range, removing lists, and dependent cascading dropdowns. October 2026.
How to Make a Chart or Graph in Excel
Which chart fits your data, per-type walkthroughs (pie, bar, line, scatter, Gantt), and customization. October 2026.
How to Lock Cells and Protect Sheets in Excel
The thing nobody tells you: locking does nothing until the sheet is protected. Full workflow plus file passwords. October 2026.
How to Unhide Rows, Columns & Sheets in Excel
Unhide everything at once, the hidden-column-A trap, unhiding sheets, and why filters fake you out. October 2026.
More guides on the way
We're publishing guides for every high-demand Excel task, in order of what people search for most. Next up:
- Learn Excel from scratch
- Excel formulas: basic math (multiply, divide, add, subtract)
- Move, copy & paste without breaking things
- Excel statistics: standard deviation, mean, variance
- Freeze panes and split windows
- Entering data faster: autofill, flash fill, data entry forms
- Pivot tables, step by step
- Cleaning messy data
- Cell styles, strikethrough & formatting
- Sort & filter done right
- Print setup: labels, headers, fit-to-page
- SUM and the aggregation functions
- Autofit column width & row height
- The IF function, explained properly
- Merging cells (and why to avoid it)