The correct answer is use the Fit to Page option to print. There are steps you need to take when encountering problems with the printout width.
Open the spreadsheet in Microsoft excel, click the page layout tab at the top of the window, select the printout button in the page set up section. Under scaling, select fit to and type” 1” in both the page wide box and pages tall box.
Select “OK” on the file menu, you can increase the tall box depending on how long you want your printout. You can preview it to see what it would look like after printing and then click print if you are satisfied with the preview.