Chris has attended:
Excel Advanced course
Pivot table
Is there a quick way to adjust text fields, e.g. names of people who are displayed with spaces added. Having the spaces added does not allow the pivot table to run correctly.
RE: pivot table
Select the emplty field just above the row number 1 and before the column heading letter A and this selects all the rows and headings and adjust the fields