Properly Handling Date Grouping in Excel Pivot Tables (Change Grouping, Get All dates)

Microsoft Excel Tips and Tricks

Working with dates in Excel pivot tables can get tricky. When you drag and drop a date field in the pivot table Excel automatically groups the dates into days, months and years. But with if you want to see the actual date and not the grouping? How can you quickly ungroup the dates? hint: There’s an Excel shortcut to ungroup dates in a Pivot Table.

Credit Leila Gharani