• Excel Book Excerpt

Excel Use Multiple Value Fields as a Column or Row Field

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Use Multiple Value Fields
as a Column or Row Field

Problem: When I create a table with two or more Values fields, Excel has those fields stretch across the column fields. Is it possible to change to other layouts?

Strategy: Look for a virtual field in the Column Labels drop zone called Values. This field can be pivoted to another location. It starts out in the column labels:

LE10000802.jpg  

Figure 773 Values go across the columns initially.

Drag this virtual field to the Row Labels and you will get a different look to the report.

LE10000803.jpg  

Figure 774 You can drag Values to the row area.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:



Popular Pages

More Info