Monday, February 8, 2010

The classic way of pivoting fields in Excel 2007

The Pivot Table user interface has changed (again) in Excel 2007. The Pivot Table interactive screen elements and Word’s Mail Merge workflow are not in any way irritating. What is irritating is that Microsoft feels they need to evolve the user interface when they progress the Office version.

For those who love the classic way of dragging and dropping fields from horizontal to vertical (and vice versa), it can be puzzling that Excel 2007 forces use of the new vertical Task Pane. The good news is that you can still switch on that drag and drop behaviour of fields on the worksheet.

pivot table ui

No comments: