If you're using Excel for Mac 2011 and earlier, the PivotTable button is on the Data tab in the Analysis group. Excel will display the Create PivotTable dialog with your range or table name selected.
![]()
I'm looking to sort the row labels in a pivot table in to a custom sort format. I've selected the rows and clicked Sort Custom Sort Then selected labels Then clicked Options.
The Sort Options appears and only a few predetermined options appear. (tried to take a screen grab below - hopefully it shows) D Does anyone know how I can sort the following into a custom order? I want them to show in the following order: Notification of Requirement In Discussion Sourcing/Advertising Shortlisting Interview and/or Assessment Offer Filled Failed / Stopped / Cancelled On Hold Withdrawn I could do this in previous versions of excel (admittedly on Windows, not Mac).
![]()
Can anyone advise? Thanks in advance!
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |