Microsoft Office Tutorials and References
In Depth Information
Notice the highlighted Sort Ascending menu that allows you to change this sort order. You
get to that menu by clicking the arrow next to the Row Labels caption. Figure 11-3 shows
the result after you choose the Sort Ascending menu item, which sorts models by name in
ascending order.
FIguRE 11-3 The PivotTable has been sorted by model name in ascending order.
As you can see in the preceding figures, saving an Excel workbook in a document library
on a SharePoint site publishes the entire contents of the workbook. In this case, all three
worksheets are visible, including those that do not have data to show (such as Sheet2
and Sheet3). You see later in this chapter how to publish only parts of the workbook on
Search JabSto ::

Custom Search