Export One Excel Sheet to PDF with All Columns on One Page Width
Export just one Excel sheet to PDF. Set the print area, fit columns to one page width and check for missing columns or unreadable scaling in the result.
Read guide →Excel data cleanup, input and CSV
Separate rules for future input from cleanup of existing data. Changing how a cell appears differs from deleting values or rows, so plan how to reverse the operation.
Before choosing a task
- Save a working copy and check headers, blank rows and merged cells.
- Use dropdowns to constrain input, or freeze panes to keep headings visible.
- When importing CSV, check leading zeros and automatic date conversion as well as character encoding.
Browser-local checking tools
- CSV inspector and UTF-8 export →
Check CSV rows and columns, rows with a mismatched column count, leading zeros and formula candidates in your browser, then save the values as UTF-8 CSV.
Follow the steps
Create a personal filter view in Google Sheets
Filter Google Sheets without changing a collaborator’s view. Create a filter view, save your sorting and conditions, and return to it when needed.
Read guide →Convert an Excel data range to a table
Turn an Excel range into a table. Check headers, filters, structured references and expansion, then add a row to see how the table behaves.
Read guide →Delete duplicate rows based on specified columns in Excel
Remove duplicate Excel rows using selected columns. Preview likely duplicates, choose the matching columns and check the remaining count before keeping the change.
Read guide →Create a dropdown list in Excel with data validation
Create an Excel dropdown with data validation. Prepare the choices, set the list rule and test both valid selections and entries outside the list.
Read guide →Freeze header row and leftmost column at the same time in Excel
Freeze rows and columns together in Excel. Choose the boundary cell, apply Freeze Panes and test vertical and horizontal scrolling, with steps to undo it.
Read guide →Import UTF-8 CSV in Excel without garbled characters
Import a UTF-8 CSV into Excel without garbled text. Choose encoding, delimiter and column types, then check text and leading zeros before loading the data.
Read guide →