Microsoft Office Excel 2010 provides numerous predefined table styles (or quick styles) that you can use to quickly format a table. If the predefined table styles don’t meet your needs, you can create and apply a custom table style. Although you can delete only a custom table style, you can remove any table style so that it is no longer applied to the data.
Choose a table style when you create a table:
- On the worksheet, select a range of cells that you want to quickly format as a table.
- On the Home tab in the Styles group, click Format as Table.
QUICK TIP: Save yourself some time, use Ctrl + T. Click anywhere in the data and click on the Ctrl + T and then press enter. With this keyboard shortcut you do not need to select the data.
|Before formatting has been applied.||After formatting has been applied.|
|Formatting your data as a table will format the heading row, add a filter, set freeze panes, and color the even rows of data all at once. Give this keyboard shortcut a try next time you need to quickly format your data.|