To change the default print settings in
Excel 2007, follow these steps:
- Open Excel 2007 and click on the Office button in the top left corner of the screen.
- Click on "Excel Options" at the bottom of the menu.
- In the Excel Options dialog box, click on "Advanced" in the left-hand pane.
- Scroll down to the "Print" section and click on the "Print options" button.
- In the Print options dialog box, uncheck the "Collate" box and any other options you want to change.
- Click on "OK" to save the changes and close the dialog box.
- Click on "OK" again to close the Excel Options dialog box.
Now, whenever you print a worksheet in Excel 2007, it should use the default print settings you just configured. If you want to change the print settings for a specific worksheet, you can still do that by clicking on "Print" and then "Properties" before printing. However, the default settings should now be what you want them to be.