Free Excel Guides: Fix Errors and Clean Your Lists
Short, practical Excel guides for the problems that cost the most time. Is VLOOKUP showing #N/A although the value is in your list? Did Excel remove the zero from your ZIP codes? Do your dates refuse to sort, does your list have double rows, or does Excel freeze? Each guide gives you up to three fixes in plain words, with formulas you can copy. Where one of our free tools saves you the work, the guide links to it. The tools run on your own computer, and your file is never uploaded. Pick your problem below.
Fix Excel errors and formulas
VLOOKUP Returns #N/A: How to Fix It (Easy Steps)
The value is in your list, but VLOOKUP does not find it. Here is the fix.
How to Clear All Filters in Excel (and Show Hidden Rows)
Rows are missing? Clear all filters and bring back hidden rows.
Clean and format your Excel data
How to Keep Leading Zeros in Excel (ZIP Codes and IDs)
Excel turns 02110 into 2110. Here is how to get the zero back.
Comma to Column in Excel: Split Text and Join Back (3 Ways)
Split comma separated text into columns, or join a column into one line.
How to Convert Text to Date in Excel (Dates Not Sorting)
Your dates do not sort? They are text. Here is how to turn them into real dates.
Remove Duplicates in Excel Without Losing Data (3 Ways)
Find double rows and remove them, without deleting the wrong ones.
Excel Keyboard Shortcuts: 30 You Need (Windows and Mac)
30 shortcuts for Windows and Mac that make list cleaning much faster.
Prepare Excel lists for mailings
Extra tip: show your Excel list on Google Maps
Free Excel tools that clean your list
Prefer to skip the formulas? The free tools clean the whole sheet on your own computer. Your file is never uploaded.
→ See all free Excel tools