The print preview and settings window that appears with Ctrl+P needs to clearly distinguish which settings are global (set once per print job) and which settings are worksheet specific (set per worksheet in preview, or in the Page Layout tab's Page Setup dialog box). Otherwise you assume that changing any setting in the print preview and settings window will apply to the print area selected (especially Print Entire Workbook).

For example, the Printer drop down and print area drop down (e.g. Print Entire Workbook) are global settings. Group these under a heading that makes that clear. Meanwhile Scaling (e.g. Fit all Columns on one page), 2-sided printing (e.g. Flip pages on short edge), and all other settings look like they would apply to all worksheets (especially if you've selected Print Entire Workbook), but in fact they only apply to all of the pages that make up the active worksheet (i.e. the worksheet you see in the preview at the time you change these settings). These should be grouped under a heading that indicates that changes here only apply to the active worksheet (the worksheet that is visible in the preview at the time the changes are made).

Further, if the workbook has been configured with different Page Setup settings between any of the worksheets, visually indicate this has been detected.

Finally, consider offering a clear option to apply a setting change, made in the print preview and setting (Ctrl+P) window), to all worksheets when Print Entire Workbook is selected.