Microsoft Excel Tips and TricksWorking 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