Excel – Remove Excel border on the right for printout

microsoft excelprint to pdfprinting

Does anyone know how to remove this right white space border on the Excel printout? I am saving to an Adobe PDF so that there should be no margins. Even if I stretch the image to the right cells it still does this.

enter image description here

enter image description here

Best Answer

Use Excel's Custom Scaling option to make your printed page just large enough to fill and eliminate the unwanted white border as follows:

  1. On Excel's ribbon click the File tab then choose Print.
  2. Below Settings click No Scaling and then chose Custom Scaling Options... from the list. enter image description here
  3. In the Page Setup dialog increase the Adjust to: percentage then click OK. enter image description here
  4. Observe the size of the right white space border and repeat step 3 until you find the correct percentage setting. The result should look similar to the following: enter image description here

Other methods to eliminate the unwanted right border involve making the content on your spreadsheet wider until there is no longer then unwanted white space on the right. You can do this a number of ways:

  1. Resize any images to make them larger horizontally.
  2. Increase the width of columns that contain content.
  3. Increase the font size of your content.
Related Question