Create a personal filter view in Google Sheets
This is the procedure for saving sorting and filtering conditions without changing the display of co-editors.
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.
Follow the steps
Convert an Excel data range to a table
Here are the steps to create a data table that can use headings, filters, structured references, and automatic expansion.
Read guide →Delete duplicate rows based on specified columns in Excel
These steps include checking the rows and matching columns to keep, deleting duplicate data, and canceling.
Read guide →Create a dropdown list in Excel with data validation
This is the procedure for setting input rules that refer to the candidate table to prevent input errors.
Read guide →Freeze header row and leftmost column at the same time in Excel
This is the procedure for fixing the frame so that the table heading continues to be displayed even when scrolling.
Read guide →Import UTF-8 CSV in Excel without garbled characters
This guide shows how to import a CSV after checking its encoding and delimiter instead of opening it directly.
Read guide →