Data Menu
To sort data.
Select the required cells.
Click on Data menu.
Click on Sort command.
Then a dialog box will appear.
Choose the required column name for sort by option.
Choose Ascending or Descending order. [If you want to sort multiple columns click on Then by option and choose the required column name.
Choose Header row or No header row from My list has option.
Click on Ok.
To Auto filter data.
Select the required columns.
Click on Data menu.
Click on Filter command.
Then click on Auto filter.
Now Click on drop down arrow list of column and choose the required options. (All, Top 10, custom etc)
To remove Auto Filter.
Click n Data menu.
Click on Filter command.
Click on Auto filter.
Creating Data form to edit data.
Select the required cell.
Click on Data menu.
Click on Form command.
Now a data form appears.
Click New button to add new record. Type the data.
To move to the next field, press TAB key.
When you finish typing data, press ENTER to add the record.
Click on Find next button to find the next records a Find prev button to find the previous records.
Click on Delete button to delete the displayed record.
Click Close to close the data form.