Remove Excel border on the right for printout

Question

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.

Solution 1

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.
3. In the Page Setup dialog increase the Adjust to: percentage then click OK.
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:

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.

Solution 2

The only way I've been able to reduce the margin on the right is under Page Layout/margins eliminate any right & left margin (make 0) and then check the "Horizontally" box under the "Center on page". I lost 3/8" on the left but gained 1 3/8" on the right so my margins are now equal from each border @ 1 1/8". (Landscape)

Comments

[Máté Juhász]

Excel is a spreadsheet application and not a design tool. Achieving a nice printout can be very difficult if not impossible. If that really matters for you, I recommend to copy your table to another program (e.g. Word)