It's actually a bug in Excel 2010, 2023 and Excel 2016. The main reason they did this was to accommodate two people simultaneously working. One person would select the sheets that they want to print and the other person would select the other sheets to print. This way they would keep printing their workbook and sharing it with another person. We can circumvent this by using the print “active worksheets” As you see from the screenshot, the columns that contain the sheets are now displayed in a column. But the sheet that the user selected is not yet printed. There is still an option to select and print the sheet that is next to it. With this the printed sheet will be the next sheet to be selected and printed. The user could do this to start printing immediately. The important point is that these options are only available when printing multiple sheets. Excel 2023 makes sense. In Excel 2023 the function printing is not available to handle multiple output. When you choose to print the same sheet multiple times, Excel creates the sheets with the same names. In Excel 2023 you can create the same sheets again with the same names, but that won't create an output file that the user will be able to choose to download. This is a bug in Excel 2016.