Tables

In this lesson you can learn how to use tables in Excel.

Since Excel 2007 there is a Table option. If you convert the data into a table recognized by Excel you will get access to many additional options. To convert the data into a table, set the active cell in the table with data from the card 'Insert', choose 'Table'.

Excel tables insert table

You will be asked to confirm whether the content is correct and click OK. data will be converted to a table.

Excel tables Create Table

For columns in which there was a header, a header will be added Column1, Column2, etc.. In the column headings Symbols giving access filter for filtering and sorting.

 Excel tables name of column header

Use the tabs 'Table Tools' 'Design', you can easily change the style of the table, for example, selecting a very liked by some people alternate coloring of rows.

Excel tables table style change light style

By clicking on the table right mouse button and selecting 'Table' à 'Row Totals' columns will add Totals Row to table.

Excel tables right click totals row

After entering the cell is a summary of what you can change the formula will be used in that cell. In the example you use the average.

Excel tables totals row average

The table has the advantage over the ordinary range of data in the case of filtering, sorting, and adding or deleting rows, both the formatting and formulas in the column of the summary will be modified accordingly. Let's sort data in ascending order by value in column C. You can do this for example, clicking on any of the table cells in column C and select 'Sort' and 'Sort smallest to largest.'

Excel tables sort smallest to largest

As you can see the formatting has been adjusted to the new layout data. That data is sorted is determined by adding the filter to the symbol in cell D3 up-arrow (sort ascending).

Excel tables sort small arrow

The tables also have such a property that, if the screen scrolls down the column headers that are no longer visible replace the letters denoting the column.

Excel tables table headers

This works only when the active cell is in the Table.

Excel tables table without headers

To convert the table back to a range of data, click any cell in the right and select 'Table' à 'Convert to range'.

Excel tables convert to range

Click 'Yes'.

Excel tables convert the table to a normal range

Since then you have to deal with the usual range, the format remains, but will not automatically change according to changes in the system data.