Excel Printing 2-sided

zedyep 10 Reputation points
2023-07-28T15:37:29.63+00:00

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.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,143 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Tanay Prasad 2,140 Reputation points
    2023-07-31T07:10:08.4133333+00:00

    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.

    0 comments No comments

  2. Emi Zhang-MSFT 27,476 Reputation points Microsoft Vendor
    2023-07-31T07:54:24.9066667+00:00

    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.

    Under Settings, click Print Entire Worksheet

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.