Special Options for Data Tables in Excel 2007:-


If you select the More Data Table options in the Data Table drop-down, you have the usual options for fill, border color, border styles, shadow, and 3-D format, plus special data table options. You can decide to hide or show the horizontal or vertical gridlines in the table and to show or hide the outline around the data table. In the Figure (specified below), the outline and horizontal gridlines are turned off, which gives the data table a cleaner look.



(Special options in the Format Data Table dialog allow you to turn on or off various elements of a data table.)