Musica edin torni

A table is a range of cells that hold data, with each row corresponding to a single occurrence of an entity. When you create...

A table is a range of cells that hold data, with each row corresponding to a single occurrence of an entity. When you create a table, you can manage and analyze the data in that table independently of data outside the table. Usually there is an initial row of text headings merge excel data into pdf form describe the columns of data. Each row in the table would hold the above details for a particular employee.


But as Excel 2010 handles tabular data perfectly well by default, why would you want to put your data into a table? Well, tables allow Excel to respond more appropriately to your data if it is held in a a table.

For example, if you create a chart based on the data in a table, the chart will expand as you add more rows to that table. If your data has headers, make sure to check the My table has headers box in the create table window, and then those headers will be used. The good thing is that you don’t need to select the entire range of cells: Excel can identify the limits of the data and also identify the headings.

admin