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
For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.
Last updated: January 24, 2017 10:06 AM
Contextures RSS Feed