Any special formatting (such as banded rows) remains in place and must be changed manually unless you remove the formatting first, using the Clear option at the bottom of the Table Styles gallery on the Design tab. This option removes the special treatment of header rows and converts formulas back to ordinary cell references. Or right-click any cell in the table and then click Table, Convert To Range on the shortcut menu. What if you change your mind and want to remove the table features, turning the data back into a plain olвЂ™ range? Easily done: Click to select any cell within the table and then click Convert To Range, in the Tools group on the Table Tools Design tab. You can also export a table to a SharePoint list or to a PivotDiagram in Visio (a member of the Office family we donвЂ™t discuss in this book), using the Export command in the External Table Data group on the Table Tools Design tab.ДЄfter you convert a range into a table, you can fine-tune its appearance with custom formatting, expand its size in either direction, and add totals. In fact, as we explain in Chapter 14, a table can serve as the source of data for a PivotTable report.

Tables offer a tremendously versatile way to work with large and small amounts of data. (For an explanation of how structured references work, see вЂњAdding formulas and totals to a table,вЂќ later in this chapter.)ДЄ triangular handle in the lower-right corner of the table allows you to quickly add rows or columns to the table, preserving formatting and copying formulas automatically. When any cell or range within the table is selected, a Design tab with customization options appears on the ribbon, under the Table Tools heading.ДЄ default name is assigned to the table you can change the name to a more descriptive one by using the Table Name box in the Properties group on the Table Tools Design tab.ДЄny cell addresses used in formulas you add within the table are automatically converted to structured references. If column headers are not included, Excel adds generic headers-Column1, Column2, and so on.ДЄ down arrow appears to the right of each column heading, allowing quick sort and filter operations. (We explain these changes in more detail shortly.)Д¬olumn widths expand as needed to display header text in full. (We discuss table styles in much greater detail in the next section, Formatting tables with table styles.)Дefining a range as a table makes the following changes, some of which are not immediately apparent. Using either keyboard shortcut applies the default table style. Had we instead clicked Format As Table, in the Styles group on the Home tab, we would have been required to select a table style before seeing the Format As Table dialog box (which is identical to the Create Table dialog box shown in Figure 13-2).

(You can also use the keyboard shortcut Ctrl+T or Ctrl+L.) YouвЂ™ll see the Create Table dialog box shown in Figure 13-2. If you want more control over the process, select the range (or select any cell within the range if the list is in a self-contained region), and then click Table in the Tables group on the Insert tab.

The quickest way to turn a range into a table is to click Table in the Tables group on the Quick Analysis tool, which applies the default table format to the current selection or region immediately. If you open a worksheet originally created in Excel 2003 that contains one or more lists, youвЂ™ll need to manually convert those lists to tables. Tables are roughly equivalent to the feature known as lists in Excel 2003, but with more sophisticated formatting options. Microsoft introduced the concept of tables (not to be confused with data tables, which are a rarely used relic of ExcelвЂ™s distant past) in Excel 2007. When you turn a range into a table, Excel provides several tools that simplify the way you work with even long, detail-rich collections of data. As long as that list remains short and simple enough to scan quickly, you donвЂ™t need to do anything more.Д«ut lists have a way of growing, and even moderately long lists can benefit from sorting, searching, filtering, outlining, and summarizing.

For example, you can enter a list of names in column A and then, in column B, enter a phone number alongside each name. You can create a simple database just by entering data into rows, with or without headings to indicate whatвЂ™s in each column. Using tables to organize and analyze data

How to insert a header in excel 2013