In a pivot table, the values can be arranged vertically or horizontally. These videos show the steps in different versions of Excel
See how to move the value fields in Excel 2010:
See how to move the data fields in Excel 2003
For written instructions, please go to Excel -- Pivot Tables -- Data Field Layout
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
Last updated: January 24, 2017 10:06 AM
Contextures RSS Feed