Insert and Delete Tables in Microsoft Excel 2010 worksheet


You can easily insert a table in your Excel worksheet and make it contain any data present in a group of cells. When you have some particular data inside a table, you can choose to edit, delete or manipulate it independent of the data that is present outside the table. Below is a tutorial that will guide you on how to insert a table in Excel worksheet in two ways and how to delete Tables that were created.


Inserting a table using an inbuilt Table style

1) Select the group of cells that you intend to include in a table. The cells may or may not contain any data within them.


Figure 1



2) Now, click on the “Insert” tab and then under the Insert tab, in the ‘Tables’ category, click on the ‘Table’ icon.


Figure 2



3) Once you click on the ‘Table icon, a ‘Create Table’ dialogue box appears on the screen. If your table contains headers, then in the dialogue box, select the checkbox that says ‘My Table has Headers’ and click ‘OK’.


Figure 3



4) Now if you observe your worksheet, a table will be inserted for the range of selected cells that you specified.


Figure 4



Inserting a table using your own choice of style

1) Select the range of cells that you want to include in a table. Here also, the cells may or may not include any data within them.

2) Now, click on the “Home” tab and then under the Home tab, in the ‘Styles’ category, click on the ‘Format as Table’ icon.


Figure 5



3) Now under the ‘Light’, ‘Medium’ or ‘Dark’ category, choose the table of your choice and click on that particular table to insert it in the worksheet.


Figure 6



4) In the ‘create Table’ dialogue box thus opened, check the box that says ‘My table has Headers’ and click on ‘OK’.

5) Now the particular table style that you chose in the previous step will be inserted in the worksheet.


Figure 7




Delete the table without losing the data present inside it

1) Click on any cell inside the table. Once you click on any cell inside the table, a ‘Design’ tab gets revealed on the ‘Ribbon’.


Figure 8



2) Under this “Design” tab, in the ‘Tools’ category, click on the ‘Convert to range’ and then click on the ‘Yes’ button.


Figure 9




Figure 10




3) Once you remove a table, the table tools options will no longer be available. For example, the row header does not contain any sort and filter options that were used for cell references.

4) You can also remove a particular table by Right clicking on that table and then selecting ‘Convert to range’ option from the drop down list.


Figure 11



Delete the Table as well as the data present inside it

1) Click on any cell inside the table and then press ‘Ctrl+A’ keys.

2) Then press ‘Delete’ key.

3) You can also click on the ‘Undo’ icon present on the Quick Access toolbar for removing a table that you just created.


So, this is how you can insert and Delete tables in Excel 2010 Application.



Read Other Applications