![]() ![]() This is a workbook level setting, so it will affect all the AutoFilters in the active workbook. If you want to see the individual dates, you can change one of the Excel options. ![]() Here’s how you can undo or prevent grouped dates in Excel AutoFilters and Pivot Tables.īy default, when you turn on an AutoFilter, the dates are grouped by year and month in the drop down list. ![]() This happens in AutoFilters, and in pivot tables too (in newer versions). If you have strict parents, that might be the only kind of dates they allow! But, in your Excel worksheets, it can be annoying when dates are automatically grouped. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |