Chennai Laptop Service
Laptop Repair Service In Chennai
Call 8681030184 ; 8754598732
Sorting & Filtering
WIIFM
Why is it important for us to know about the Sort & Filter options? :
-- To save time while arranging data.
-- To be able to use the „filter‟ option to focus on specific data in a large spreadsheet.
12.1. Sorting: Ascending Order (A-Z), Descending Order (Z-A)
-- Use the above example.
-- Select a cell in the column you want to sort.
-- Click the „Sort & Filter‟ command in the „Editing‟ group on the „Home‟ tab.
-- Select „A-Z‟.
-- This will sort the numbers in an ascending order for you.
12.2. Filter Data
The „Filter‟ command helps us to focus on specific information.
-- Create a new workbook.
-- Enter the data as displayed below: