Data Cleaning
How to Remove Blank Rows in Excel (delete them all at once)
How to remove blank rows in Excel in one go: Go To Special for fully empty rows, the filter method for partly empty rows, and the mistake that deletes real data.
Learn Excel the easy way.
Short, plain-English tutorials on formulas, shortcuts, charts and everyday Excel tasks. No jargon. One idea per post.
Start here Get Daily One LessonLatest tutorials
Charts
Excel Line Graph: show a trend over time
Make an Excel line graph in four steps, add a second line, fix the axis that starts at the wrong number, and add data labels.
Import, Export & Convert
Excel vs Google Sheets: which should you learn?
Excel vs Google Sheets compared on what matters to a learner: cost, sharing, formulas, big data, offline use, and whether skills transfer.
Fixes & Errors
Excel Circular Reference: find it and fix it
Excel says there is a circular reference: what it means, how to find the exact cell, and how to fix the two usual causes.
Fixes & Errors
Excel Not Responding: what to do right now, and how to stop it
Excel not responding? What to do in the next 60 seconds to save your work, then the five causes that make it freeze and how to fix each.
Print, Share & Protect
Set a Print Area in Excel: print only the part you want
Set a print area in Excel so only your table prints, fit it on one page, repeat the heading row, and clear the area when done.
Import, Export & Convert
Excel to CSV: save a sheet as a clean CSV file
Save Excel as CSV the right way: which CSV type to pick, why only one sheet is saved, and how to keep leading zeros and dates intact.
Import, Export & Convert
CSV to Excel: open it without breaking the numbers
Open a CSV in Excel properly: keep leading zeros, stop dates flipping, handle a file where everything landed in one column, then save as .xlsx.
Pivot Tables & Tables
How to Make a Pivot Table in Excel: summarise 1,000 rows in 30 seconds
How to make a pivot table in Excel step by step: sales by region, count by category, drag fields, refresh when data changes.
Showing 244–252 of 294 tutorials · Page 28 of 33
