Excel Printing 2-sided

Question

We have a user that was trying to print selected worksheets 1-sided. He would select "Print One Sided" but when he printed only the first page would print 1-sided and the rest were 2-sided. We discovered that we had to go through and manually select "Print One Sided" for every single worksheet individually to get it to print all of them 1-sided. We checked that the printer was set to print 1-sided by default and that the printer driver on the user's machine was also set to print 1-sided by default. My understanding is that with both of those settings on print 1-sided that this shouldn't be happening.

Is there another setting that I am missing? Any help would be appreciated.

Answer 1

Hi,

You can take the following actions to make sure that all worksheets in the workbook are printed one-sided by default:

1. Open the Excel workbook containing the worksheets you want to print 1-sided.
2. At the bottom of the Excel window, select the top worksheet tab.
3. On the Excel ribbon, select the "Page Layout" tab.
4. Click on the "Dialogue Box Launcher" icon (small arrow) in the bottom-right portion of the "Page Setup" group. With this, the current worksheet's "Page Setup" dialogue box will be displayed.
5. In the "Page Setup" dialog box, go to the "Sheet" tab.
6. Verify that the "Print on one side" option is selected under the "Print" section. Select "Print on one side" from the dropdown menu if it isn't already selected.
7. Click the "OK" button to apply the settings for the current worksheet.
8. For every worksheet in the workbook, repeat steps 2 through 7.

When the user chooses "Print One Sided" from the print settings, you should make sure that all worksheets in the workbook are printed 1-sided by setting all of them to "Print on one side" in their respective "Page Setup" dialogue boxes.

Best Regards.

Answer 2

Hi,

I suggest you select File, and then click Print, under Settings, select the arrow next to Print Entire Workbook and select the appropriate option.

Then you can set the Print side you need.

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

I did as advised however the printer still printed both sides instead of one side only. How do we trouble shoot this?