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;
Create a Pivot Table in Excel 2003. 1  Select a cell in the database. 2  Select 'Microsoft Excel List or Database', click Next. 3  For the range, type your range name, e.g. 4  Click Next. 5  Click the Layout button. 6  Drag field buttons to the row, column and data areas. 7  Click OK, click Finish.reate a Pivot Table in Excel 2003. 1  Select a cell in the database. 2  Select 'Microsoft Excel List or Database', click Next. 3  For the range, type your range name, e.g. 4  Database. 5  Click Next. 6  Click the Layout button. 7  Drag field buttons to the row, column and data areas.