01
HOW TO
How to Sort and Organise a Large Excel Spreadsheet
Got a huge Excel spreadsheet? Here’s how to organise, sort and filter it without separating records or turning the workbook into a crime scene.
Read the guideFAFF IT OFF · FAFF IT YOURSELF
Fix the faff yourself.
Straightforward guides for spreadsheets, PDFs, data and the little digital jobs that somehow eat an entire afternoon.
THE DEAL
Teach the easy bit.
Faff off the horrible bit.
If it is a quick fix, we will show you how. If the file is enormous, broken, badly behaved or simply not how you want to spend your day, send it our way instead.
THE FAFF LIBRARY
Pick your problem.
10 guides · newest first
02
HOW TO
How to Extract Data From a PDF Into Excel
Need specific data from a PDF in Excel? Here’s how to extract tables, handle scanned documents and check the result before relying on it.
Read the guide
03
HOW TO
How to Merge Data From Two Excel Spreadsheets
Need to match and merge data from two Excel spreadsheets? Start with a reliable key, check your matches and avoid the usual duplicate-row trap.
Read the guide
04
HOW TO
How to Fix Excel Formulas That Aren’t Working
Excel formula not working? Check these common causes before you threaten the laptop: calculation mode, text values, references, errors and more.
Read the guide
05
HOW TO
How to Clean Up a Messy Excel Spreadsheet
Messy Excel spreadsheet? Here’s a sensible clean-up order for duplicates, blank rows, inconsistent formats, bad headings and general spreadsheet carnage.
Read the guide
06
HOW TO
How to Convert CSV to Excel Properly
CSV file gone feral in Excel? Here’s how to import it properly so columns, dates and numbers behave themselves.
Read the guide
07
HOW TO
How to Combine Multiple Excel Files Into One
Got several Excel files that need turning into one usable spreadsheet? Here’s how to combine them without creating a copy-and-paste disaster.
Read the guide
08
HOW TO
Need Help With Excel? 10 Common Spreadsheet Problems and How to Fix Them
Excel playing up? Here are 10 common spreadsheet problems, what usually causes them, and how to fix them without losing an afternoon to spreadsheet…
Read the guide
09
HOW TO
How to Remove Duplicates in Excel Without Losing Your Data
Got duplicate rows or values in Excel? Here’s how to find and remove them safely without accidentally deleting data you need.
Read the guide
10
HOW TO
How to Convert a PDF to Excel Without Making a Complete Mess of It
Need to turn a PDF into an Excel spreadsheet? Here’s how to do it, what can go wrong, and when it’s easier to Faff…
Read the guideSTILL LOOKING AT THE FILE?
Can't be faffed?
Tell us what you have. Tell us what you need at the end. We will tell you what it costs to make the problem disappear.