Insert Table in Excel 2010

In this article I am going to explain about Insert table in Excel 2010.
  • 2827

Insert Table in Excel 2010

Excel Provide table properties by which we can convert cell range in to the table format. After converting cell range in to the table Filter button automatically will be added.

To Insert table we have to follow following steps.

Step 1

Open worksheet and select cell range where we want to create table.

tab1.jpg

Step 2

In Insert tab click on Table.

tab2.jpg

Step 3

A dialog box will be appear where can set the cell range.

tab3.jpg

Step 4

Cell range will be convert in table.

tab4.jpg

Step 5

After creating table a button will be display on the top of column by which we can sort to data and filter to data of the table.

tab5.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.