Home >Topics >excel >How to sort birthdays in excel by month and day

How to sort birthdays in excel by month and day

藏色散人
藏色散人Original
2020-03-24 09:14:3518966browse

How to sort birthdays in excel by month and day

How to sort birthdays in excel by month and day

Excel 2003:

1. Select In any cell in the A1:B18 range, click the menu "Data → PivotTable and PivotChart", and click the "Finish" button in the dialog box.

2. Drag the "Date of Birth" field and the "Name" field to the row area, and the "Name" field should be located to the right of the "Date of Birth" field.

3. Cancel summary items: Right-click any cell in the "Date of Birth" field and select "Field Settings" in the pop-up shortcut menu.

How to sort birthdays in excel by month and day

In the pop-up "PivotTable Fields" dialog box, select "None".

How to sort birthdays in excel by month and day

4. Right-click any cell in the "Date of Birth" field again, and select "Group and Display Detailed Data→Group" in the pop-up shortcut menu. In the "Group" dialog box, select "Day" under "Step", and "Month" and "Day" are selected at the same time. Click the "OK" button.

How to sort birthdays in excel by month and day

# Excel automatically groups and sorts "name" by month and day.

How to sort birthdays in excel by month and day

Excel 2007:

1. Select any cell in the A1:B18 range, select the "Insert" tab in the ribbon, and click Select "PivotTable → PivotTable" in the "Table" group. Click the "OK" button in the pop-up dialog box.

2. In the "Pivot Table Field List", first check the "Date of Birth" field, and then check the "Name" field. In the Row Label, the Date of Birth field is above the Name field.

How to sort birthdays in excel by month and day

3. In the pivot table, right-click any date and select "Group" in the pop-up shortcut menu. The "Group" dialog box pops up, select "Day" under "Step", and "Month" and "Day" are selected at the same time. Click the "OK" button.

How to sort birthdays in excel by month and day

#Excel automatically groups and sorts "name" by month and day.

How to sort birthdays in excel by month and day

The above is the detailed content of How to sort birthdays in excel by month and day. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn