click "Table," or use the Microsoft Excel keyboard shortcut, Ctrl+T. Now, in the Create Table dialog box, double-check that the whole range is selected, make sure "My Table Has Headers" is checked ...

In fact, some advanced Excel features ... The Create Table pane will pop up with the data range prepopulated. After you click OK, the table will appear in place of the plain data you selected.

3. Take the Format but Ditch the Table Formatting data as an Excel table is the quickest way to achieve a neatly formatted range of cells in Excel. The only potential problem is that it may seem ...

Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you! Tables are new to Excel 2007 and at first, you might think ...