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.
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.
0 comments:
Post a Comment