Excel 2000 : A Sample Application    Pivot Tables  

Now all of the Date entries appear, which isn't necessarily what we want. If we wanted to look at all of the raw Date data, we could have stayed with the original data table.

Let's group the Dates by month. Right-click on any cell with Date data. A pop-up menu appears. Choose Group and Outline - Group.

 
screenbooks home site

12 of 35
  Text Author: Joe Orr   Copyright 2000 All Rights Reserved  
  Created with ScreenBook Maker   Last update: 12/20/2002   Additional Trademark and Copyright Information