Sample Data Example:

Sorting Example

Sorting changes only the order of data, not the data itself.

Example 1: Salary High → Low

Steps:

1. Select the full table.
   

2. Go to Data Tab → Sort.
   

3. Choose:
   

• Column = Salary
  

• Order = Largest to Smallest
  

4. Click OK.
   

Result:

Name	Salary
Amit	50000
Karan	45000
Neha	42000
Rahul	35000
Priya	30000

Only the order changes. No data is deleted.

Example 2: Multiple Column Sorting

Condition:

• First sort by City (A → Z)
  

• Then sort by Salary (High → Low)
  

Steps:

1. Go to Data → Sort.
   

2. Click Add Level.
   

3. Set:
   

• Level 1 → City (A to Z)
  

• Level 2 → Salary (Largest to Smallest)
  

This allows advanced sorting using multiple conditions.

Filtering Example

Filtering shows only selected data and temporarily hides the rest.

Example 1: Department = IT

Steps:

1. Go to Data → Filter.
   

2. Click the dropdown in Department column.
   

3. Select only "IT".
   

Result:

Name	Department
Amit	IT
Karan	IT

Example 2: Marks > 80

Steps:

1. Click Filter dropdown in Marks column.
   

2. Select Number Filters → Greater Than → 80.
   

Result:

Name	Marks
Rahul	85
Neha	90
Priya	88

Advanced Filtering Example

Condition:

• City = Delhi
  

• AND Marks > 85

Step 1: Create Criteria Range (In Sheet)

City	Marks
Delhi	>85

Step 2:

1. Go to Data → Advanced Filter.
   

2. Select:
   

• List Range (Full Data)
  

• Criteria Range (Above Table)
  

3. Click OK.
   

Result:

Name	City	Marks
Neha	Delhi	90
Priya	Delhi	88

Advanced Filter allows multiple conditions with AND / OR logic for more powerful filtering.