Open Microsoft Excel and then start creating a spreadsheet with the help of the File button which has an option of “New” spreadsheet. Know the columns that will contain the data which needs to be sorted out by you. If you will not know what columns or rows that data is kept then you won’t be able to input the formula correctly and the data sorted will be incorrect because some of the data will be omitted or extra data will be kept in the query.
Click the “Home” tab and browse the “Cells” that needs to be sorted out. Click in the “Insert” option and choose the “Insert Sheet Rows” option. You must put a caption at the top of each column so that you can distinguish each column from others like Name, National Identity Card number, Address, Phone Number, Gender, Qualification etc.
Select all rows that need to be sorted out. Highlight them very carefully and make sure no data is left so that you sort out the right collection of data. You can select the columns by choosing the header only because the whole column is selected automatically.
Go to “Data” tab. Click “Sort & Filter”. Click “Filter”. Choose columns and click “Sort”.