Remove the check mark from Group Dates in the AutoFilter menu.Scroll down to the Display Options for This Workbook section.On the Ribbon, click the File tab, then click Options.Here are the steps for changing the Group Dates option: Here is a link to the page How to Change the Setting This video shows the steps, and the written instruction are below the video. 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 |