Pivot tables

Resolved · Low Priority · Version 2003

Fri 21 Nov 2008, 15:40 Delegate Paula said...

Paula has attended:
Excel Advanced course

Pivot tables

how is the best way to sort data to use in pivot tables?

Thu 4 Dec 2008, 09:47 Trainer Mark said...

RE: pivot tables

Hi Paula

Thanks for the post - sorry for the late reply

The best way to sort your data will be totally up to yourself i tend to put one field in every area of the pivot table area, but this does depend on how much data you have but you will need to move things around to see which one suits you best

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Wed 10 Dec 2008: Automatically marked as resolved.

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips

Pivot tables

Pivot tables

RE: pivot tables

Excel articles

Excel tip:

Multiple Lines of Text in a Cell