Ms Excel: Merge cells and Sort/Filter

Merge & center:

It is very easy to merge cells and align the text in center in Ms Excel. To do it, select the number of cells which you want to merge and click 'Merge&center' option from the 'Home' tab.This will merge the cells and align the text to the center.

To un-merge the cells just click 'Merge&center' option once again.

Sort and Filter:

Sort:

To sort the values, first select the cells which you want to sort , then select 'Sort&Filter' option from the 'Home' tab and click on 'Sort A to Z' or 'Sort Z to A' according to your need. Moreover you can click on 'Custom Sort' to try more options.

For example, to sort the student list in alphabetical order, click on 'Sort A to Z', it will sort the values.

Filter:

To filter the data in Ms excel ,first select the column which you want to filter and  use 'Sort & Filter' option from the 'Home' tab and click on 'Filter' option.It will help us to select particular values from that particular cell.

For example, we have a mark-sheet which consists of students from different classes, and we want to view students from a class 8th only, then we can use filter option and select class '8' . This will show data related only to class 8th.

To learn about Data Validation in Excel click on MS Excel: Data Validation