Page 54 - ModularV1.1 _c6_flipbook
P. 54
Step 3 Type the desired field value that
you want to search. In this case,
we have typed the Employee
Code value A1114.
Step 4 Press the Enter key. The searched
record will appear if it exists.
Deleting a Record
Typing value to search Searched result
Perform the following steps to delete a
record:
Step 1 Move to the record that you want to delete by clicking on the
Find Next or Find Prev button.
Step 2 Click on the Delete button. The record will be deleted from
the worksheet.
Deleting a record
SORTING DATA
Excel can arrange the selected data in ascending or descending order. This is
called sorting of data. To sort data, follow these steps:
Step 1 Select the data to be sorted.
Step 2 Click the Sort & Filter command from the Editing group under the
Home tab to open a drop-down list.
Unsorted data
Using Sort & Filter command
Step 3 Click Sort A to Z (for text) and Sort smallest to largest (for numbers)
to sort the data in ascending order. The selected data gets arranged in
ascending order.
Custom Sort Sorted data
If more than one column is to be sorted in such a way that the first column is in ascending order
and if some data is the same for more than one row, then the selected column of such rows gets
sorted in descending order. You can do this in Excel using Custom Sort.
To use Custom Sort, follow these steps:
Step 1 Select the range of columns to be sorted.
Step 2 Click the Sort & Filter command from the Editing
group under the Home tab to open a drop-down list.
Step 3 Click Custom Sort from the drop-down list to open the
Sort dialog box. Unsorted data
52 Modular (Ver. 1.1)-VII

