Sorting and Filtering

Sorting

Select data → Data → Sort. Add levels in the dialog (sort by City, then by Amount). Always include the full range so rows keep together - Excel knows through Excel Tables or automatically extending selection.

Filtering

• Select the header row → Data → Filter (or click the table filter icon).
• Click a header dropdown: sort, filter by value/color, or search the column text.
• Combine filters across columns (e.g. City Delhi AND Status Paid) - all apply together.
• The status bar confirms count of visible rows.

Advanced Filter and Unique Values

Data → Advanced lets you write criteria ranges, and Unique records only extracts de-duplicated lists. Simpler: Data → Remove Duplicates for one-shot cleanup.

Filtering Dates and numbers

• Date filters: This Week, Last Month, Year to date, Between.
• Number filters: Top 10, Above Average, Between, Custom.

Key Points

• Filter shows a subset without deleting anything - clear the filter to see all.
• Sort and filter work column-by-column; keep records intact by selecting whole tables.
• Remove Duplicates is destructive - copy data first if unsure.