To shrink the wax remnant from the sides of the glass initially, you can also put the candle in the freezer for a few hours.
Example 2: Group a Pivot Table by Range. Imagine you have created the pivot table on the leftshown above, which groups 150 children according to age. The ages range from 5 to 16 years. If you want to group the ages into the age ranges 5-8 years, 9-12 years and 13-16 years, you can this as follows: 1  Right click on left column of the pivot table (containing the ages) and select the option Group...; 2  You will be presented with the 'Grouping' dialog box for numbers;
You will need a spreadsheet with several entries in order to create a Pivot Table. 1  You can also create a Pivot Table in Excel using an outside data source, such as Access. 2  You can insert the Pivot Table in a new Excel spreadsheet.y default, Excel will select all of the data on your active spreadsheet. You can click and drag to choose a specific part of the spreadsheet, or you can type the cell range in manually. 1  If you are using an external source for your data, click the Use an external data source option and click Choose Connection... .