Change Page Size

Question

I am trying to change the page size of my excel sheet to fit my 4x6" label printer.

There used to be an options button in the margins tab of of page setup where I could change the printer and select a proper pager size. That seems to be missing from the new 2016 version.

I thought that maybe it would determine the page size based on the default printer in OSX. However even after I change the default printer to my label printer it still only gives me the standard paper sizes.

Someone said that you can change it when you go to print but in that case it just tries to print an 8.5 x 11in page on a 4x6 sheet and a lot of clipping occurs.

Anyone have any idea how to make this work with my label printer?

Answer 1

Try the steps specified here to change the page size.

https://support.office.com/en-us/article/Scale-the-sheet-size-for-printing-in-Excel-2016-for-Mac-2df8518d-1f6f-4fc5-99de-8a4d12bd4565

Answer 2

This doesn't work. I think because the print size is smaller than the page size that it doesn't format correctly. It just ends up taking the top left corner of the print area. The page setup doesn't allow for my paper size?

Answer 3

Here is my solution:

In this case, I am printing on a 4x6" label printer. I leave everything formatted as 8.5x11 and then go to print. I changed the print option to the paper handling section, check the scale to fit paper size box. And then change the destination paper size to the one I want. If you scroll to the bottom of the list you should be able to find your custom size.

Warranted, this is biggest failure of office 2016 and this solution is the most techneck i have seen in a while. But, it worked for me, so hopefully it helps you and any body else that stumbles into this solution.