Apply a Excel2007 table style for data summarization

Small Zhang to the data summary of a table, if the usual way to operate, it seems too time-consuming. Is there a simple and quick way? Of course there are, I'll teach you to use table styles to summarize data.

① First, open the Excel table that you want to work with, select the data area, and click the menu bar-start-style-to apply the table style.

② from the pop-up menu, select the second line in the middle of the second style.

③ pop-up Form dialog box, we can directly determine.

④ Check the summary row in the Design tab so that the summary row is visible below the table to facilitate subsequent calculations.

⑤ Click the drop-down arrow to select a sum.

After the ⑥ sum rollup is finished, click the transform in the tool functional group to the regional option.

⑦ is converted to a region, so there is no drop-down arrow, and Data rollup is achieved.