Use cases
What you can ask for
Every example below is an instruction you can paste in as it is. Combine several in one sentence and they all run together, in one pass over the file.
- 01
Pick rows by a condition
Numbers, text, statuses, any combination of AND and OR. Case does not matter.
Example instruction
Keep rows where region is EMEA (case-insensitive) and status is not cancelled
- 02
Nothing is ever lost
The rows that were cut always land on a separate tab. You do not have to ask for it — it happens on its own.
Happens automatically
Every result has a "filtered rows" tab
- 03
Keep only the columns you need
Drop the extra columns, or go the other way and keep three out of thirty.
Example instruction
Keep every row, but only the Region, Product and Amount columns
- 04
Rename headers
Bring column names into your own format without touching a single value.
Example instruction
Rename the Region column to Sales Region, and Amount to Total Amount
- 05
Sort and take the top
Sort by any column, or take the N largest straight away.
Example instruction
Keep the three rows with the largest Amount, from largest to smallest
- 06
Remove duplicates
By a single column, or by a combination of several.
Example instruction
Remove repeated Email values, keeping the first occurrence of each address
- 07
Tidy the data up
Stray spaces, inconsistent case, empty cells, numbers stored as text.
Example instruction
In the Raw Amount column the numbers are stored as text with spaces. Turn them into numbers and keep the rows where the result is at least 500
- 08
Add a calculated column
A new column holding a computed value — a difference, a percentage, a share.
Example instruction
Add a Margin column holding the calculated value of Revenue minus Cost
- 09
Highlight what matters
Colour a whole row or single cells, several rules in different colours, bold text.
Example instruction
Highlight the Status cell in red where the status is cancelled, and the Amount cell in green where Amount is at least 1200
- 10
Split across tabs
A separate tab per category, each with the set of columns you need.
Example instruction
Keep rows where Amount is over 500, and move the ones with status overdue onto a separate tab named overdue
- 11
Compute with Excel formulas
Live formulas rather than frozen numbers: a total under the table, or a formula on every row.
Example instruction
Add a Total column where every row holds the Excel formula Amount multiplied by Quantity
Combine them
An instruction does not have to do one thing. Ask for the rows, the columns, the sorting and the colours at once, and you get a single workbook back.
Example instruction
Keep rows where status is not cancelled, keep only the Region, Product and Amount columns, sort by Amount from largest to smallest and highlight the Amount cell in green where it is at least 1200
One page per task
The ten things people ask for most, each with the instruction to paste and a worked before-and-after.
Try it on your own file
Create an account, upload a spreadsheet and paste in one of the instructions above.