![]() ![]() In the “Data options” section, add a check mark to “Disable automatic grouping of Date/Time columns in PivotTables”. ![]() Click Options, then click the Data category.At the top of Excel, click the File tab.NOTE: This is an application-level setting, not a setting for individual workbooks or pivot tables. Thanks to Sue, who pointed out this option in the comments below. Now, you can simply change one of the Excel options, to stop pivot table date grouping. You don’t have to use workarounds or make changes to the registry. If you’re using Excel 2019 or Excel for Office 365, there’s good news. That removes the extra columns, and just leaves the original date field. or, right-click on one of the date fields, and click Ungroup.press Ctrl+Z, immediately after adding the date field.To get rid of the date grouping in a pivot table, Extra columns were created, to show the Years and Quarters, as well as the Order Date. Here’s a pivot table in which I added the Order Date field to the Rows area. Starting in Excel 2016, dates are automatically grouped in a pivot table. Click the Workbook Appearance command, then click Toggle Filter Grouping. Or, if you have my Excel Tools add-in, that macro is built in. If ungrouping dates is something that you do frequently, you can use a macro to turn the grouping option on or off. Remove the check mark from Group Dates in the AutoFilter menu. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |