Select a summary in the Excel drop-down list

Select a summary in the Excel drop-down list

Select a summary in the Excel drop-down list Select a calculation method using the Drop-down list what is it like? See Animation:

Already know how to set it? Press the return key.

Do not know how this effect is set? Keep looking down.

Let's show you the data sources we use:

1. First convert the data region to a table click any cell in the data range, and then click Insert, Table. Pop The Create Table dialog box, leave the default options, and click OK. Create a list complete.

The data table becomes the following. Click any cell in the list area, and the ribbon will also have a Table Tools tab.

2, set the Total row click any cell in the list, and then click the Design tab to check total rows.

OK, as long as the mouse click on the summary row, you can see the Drop-down button, how to sum up, their own choice. If you filter the data, the results of the summary row can also be updated in real time.