O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Organizing Data into Levels

Organizing Data into Levels

After you have sorted the rows in an Excel worksheet or entered the data in such a way that it doesn’t need to be sorted, you can have Excel calculate subtotals, or totals for a portion of the data. In a worksheet with sales data for three different product categories, for example, you can sort the products by category, select all of the cells that contain data, and then open the Subtotal dialog box.

Organizing Data into Levels

In the Subtotal dialog box, you can choose the column on which to base your subtotals (such as every change of value in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required