To quickly create a table in Excel, do the following: You can create as many tables as you want in a spreadsheet. Sizing handle A sizing handle in the lower-right corner of the table allows you to drag the table to the size that you want.ДЇor other ways to resize a table, see Resize a table by adding rows and columns. If you want to include hidden rows in your calculations, you can change the SUBTOTAL function arguments.ДЇor more information, also see Total the data in an Excel table. When you select one of these options, the table will automatically convert them to a SUBTOTAL function, which will ignore rows that have been hidden with a filter by default. Total row Once you add a total row to a table, Excel gives you an AutoSum drop-down list to select from functions such as SUM, AVERAGE, and so on. For more information, see Use calculated columns in an Excel table. For more information, see Turn Excel table headers on or off.Д«anded rows Alternate shading or banding in rows helps to better distinguish the data.Д¬alculated columns By entering a formula in one cell in a table column, you can create a calculated column in which that formula is instantly applied to all other cells in that table column. You can turn off the header row in a table. For more information, see Filter data or Sort data. Every table column has filtering enabled in the header row so that you can filter or sort your table data quickly.

Header row By default, a table has a header row.

Learn about the elements of an Excel tableДЄ table can include the following elements: For more information about data tables, see Calculate multiple results with a data table. Note:В Excel tables should not be confused with the data tables that are part of a suite of what-if analysis commands.

Microsoft office suite 2010 overview