Steps for converting XLSX file into XLS file

This post will explain the steps for converting XLSX files into XLS file. XLSX is the format of spreadsheet files created by Microsoft Off... read more

Sharing and Protecting Excel Sheet.

Excel is having an useful feature for sharing the content across many users. Consider below scenario. You are having around 100 test cases i... read more

How to change Row of Data into Column Data in Excel?

Sometimes we may need to rearrange the Data arranged in a Row into Data under columns. Refer the above screenshot showing Employee name and ... read more

Excel - Removing duplicate values

We can remove duplicate entries in a list using MS-Excel. Click Data->Filter->Advanced Filter in the Excel sheet. Check the 'Uniqu... read more