Wednesday, January 20, 2010

Change column order in Pivot Table

To change the column order in Pivot Table, We can right click on th ecolumn and say move right or move left. But, the easiest way to do it is to type the column names int he required positions.

For example, if ODI,T20,Test is the current order, to change it to ODI,Test,T20, we need to change the column name in T20 to Test.

This will automatically move the contents of the column also.

Regards,
Praveen KVC
20 January 2010

1 comments:

Rajul Khona said...

Thank you! It was really helpful :)

Post a Comment