Guides
Step-by-step help for everyday file tasks and Excel, on any device.
PDF files
- How to combine multiple photos into one PDF (iPhone, Android, Windows, Mac)Several ways to turn a set of photos into a single PDF on any phone or computer, with the built-in options and a browser tool.
- How to reduce a PDF's file size for email, and why some PDFs won't shrinkWhat actually makes a PDF large, what compression can and can't do, and what to try when a PDF is still too big to send.
- How to extract specific pages from a PDFSave only the pages you need from a longer PDF, on a computer or a phone, without printing or retyping anything.
- Why can't I copy text from my PDF? (Scanned PDFs and OCR explained)How to tell a scanned PDF from a text PDF, why selecting text sometimes fails, and what OCR can and can't do about it.
- How to rotate a PDF and save it permanentlyFix sideways or upside-down pages so they stay fixed when you save, share or print the file, not just in your viewer.
Images
- JPG vs PNG vs WebP vs HEIC: which image format should you use?A plain-language comparison of the four image formats you meet most, and which one to pick for photos, screenshots, websites and sharing.
- How to open and convert HEIC photos on WindowsWhy iPhone photos arrive as HEIC files, how to view them on Windows, and how to convert them to JPG when an app or website won't accept them.
- How to resize an image without stretching or blurring itAspect ratio, pixel sizes and why making an image bigger rarely works, with practical steps for getting the size you need.
Spreadsheet and CSV files
- How to convert an Excel sheet to CSV without losing leading zerosKeep ZIP codes, IDs and phone numbers intact when you save a spreadsheet as CSV, and when you open the CSV again.
- CSV opens in one column? Comma vs semicolon delimiters explainedWhy a CSV file sometimes opens with everything squeezed into column A, and how to open it correctly in Excel, Numbers and Google Sheets.
- How to open a CSV file on Windows, Mac, iPhone and AndroidFree ways to open and read CSV files on any device, including files too large for Excel, without mangling the data.
Word documents
Excel formulas and features
- How to compare two lists or sheets in Excel and find the differencesFind what's in one list but not the other, spot matching and changed rows, and highlight differences between two sheets, with formulas that work in every Excel version.
- How to use IF in Excel: multiple conditions, nested IF, IFS and AND/ORWrite IF formulas that check one or several conditions, return text or numbers, and don't break on blanks or errors, with versions for older Excel.
- VLOOKUP vs XLOOKUP vs INDEX/MATCH: how to look up values in ExcelFind a price, name or status using a code or ID, from the same sheet or another one, and choose the right lookup function for your Excel version.
- How to link and combine data from multiple sheets in ExcelReference cells on other sheets and workbooks, total the same cell across many sheets, pull matching rows from another sheet, and keep links from breaking.
- How to combine text in Excel: &, CONCAT, TEXTJOIN and keeping number formatsJoin first and last names, build addresses and IDs, add separators, skip blanks, and keep dates and currency formatted when you combine cells.
- How to clean up messy text in Excel: TRIM, CLEAN, SUBSTITUTE and moreRemove extra and invisible spaces, fix capitalization, strip unwanted characters and split text into columns, so lookups and filters stop failing.
- How to use SUMIFS and COUNTIFS with multiple criteria in ExcelTotal and count rows that match several conditions, such as a region and a date range, with worked examples and fixes for results that come out as zero.
- How to make a chart in Excel that's clear and updates itselfPick the right chart for your data, build it step by step, combine two chart types, and make it grow automatically when you add new rows.
- How to make a data entry form in Excel (and drop-down lists)Use Excel's built-in data form, drop-down lists and input rules to enter rows quickly and consistently, or collect answers with a shared online form.
- How to find, highlight and remove duplicates in ExcelHighlight duplicate values, count how often each one appears, list unique values, and remove duplicate rows safely without losing data you need.