Excel Study · Module 2: Entering & formatting data
Class 18Sort data the right way
Basics1:22 videoFree
Click ONE cell in a column and choose Data → Sort A to Z (or Z to A): Excel sorts the whole list and every row moves together, so names keep their sales.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, my data in A1:C8 has the headers Name, Region and Sales. How do I sort it by Region from A to Z, and then by Sales from largest to smallest? Answer in short steps.
The answer that works
✓ checked in Excel2. Go to Data tab, click Sort. 3. In the dialog, confirm "My data has headers" is checked. 4. First rule: Sort by Region, Order = A to Z. 5. Click Add Level. 6. Second rule: Then by Sales, Order = Largest to Smallest.
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.