Hi All,
In pivot table sometimes we have to drag fields to arrange them in proper way.One can do this without using mouse.Yes you heard me correct.Just type the field name which you want to bring.It promptly obliges you. For e.g we have column fields as East, North, South & West in range B4:E4 .If you want to arrange them like East, West, North & South then type West in C4. You are done!
In pivot table sometimes we have to drag fields to arrange them in proper way.One can do this without using mouse.Yes you heard me correct.Just type the field name which you want to bring.It promptly obliges you. For e.g we have column fields as East, North, South & West in range B4:E4 .If you want to arrange them like East, West, North & South then type West in C4. You are done!