Thursday, March 10, 2011

Convert Data Into Table Format

In Microsoft Excel we have an option to enter data in cells and we can later on change them into table with custom format. In Microsoft Excel 2010 we have a button on the ribbon Styles under Home tab. It has a number of predefined  set of table formats that suits our likes and data presentation. 

Steps to convert data in to predefined table format: 

1)  Select the data to be put in table 

2) Click on Format as Table in Style ribbon Under Home Tab

3) Choose a format to get it applied to the selected data. 

This is the easiest way to apply a format to a data giving it a brighter look as a table where we can even sort the data by clicking on the down arrow beside Column Heading. 


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More