Scale your spreadsheet to fit on one page when printing from Excel. Microsoft Excel.
Set the Scale to Fit options for Width and Height to the values you want. Print your spreadsheet. Enter the number of pages wide and tall you want your spreadsheet to be when printed. For example, you may choose to set your spreadsheet to be 1 page wide and 2 pages tall when printed. Scaling an Excel spreadsheet to a specific number of pages Suppose you want your Excel spreadsheet to print out one page wide , but you don't mind how many pages tall the print out is. Set the Scale to Fit option for Width to be 1 page. Set the Scale to Fit option for Height to be Automatic.
Open Page Setup.
Mac Excel 16.9 Printing a page in landscape
Click the Page tab. Click the Fit To option. Enter 1 for the number of pages wide. Delete the value for the number of pages tall and leave it blank. Want to learn more? Try these lessons: Scale your Excel spreadsheet to fit your screen. Print an Excel spreadsheet with page numbers.
Print an Excel spreadsheet with header rows at the top of every page. Select cells quickly and easily in Excel using the keyboard instead of the mouse. Freeze or lock rows and columns in an Excel worksheet. Search for a lesson. Similar lessons Scale your Excel spreadsheet to fit your screen. Our Comment Policy. Add a comment to this lesson. Comments on this lesson I am quite a savvy Excel user Worked for me, thx!
Get smarter in just five minutes
Thanks for the helpful tip! The number of pages it prints will depend on how many pages tall. Hi Otto Sounds like it's working as designed, except Excel is getting confused about what you want to print and including cells that you don't want to include in the printout. There are a couple of possibilities that might be causing you to have problems: You have manual page breaks in your spreadsheet. This will cause the technique outlined here to fail.
You can also edit these files. For each preset, expand com. Oct 28, AM. When I save current settings as a preset it also safes the landscape or portrait mode and this can't be changed anymore on the printing dialog window. Do I really need to setup the exact same presets for different page orientations? That's a bug I hope it get fixed soon! Oct 29, AM. You were right It happened again and I used your instructions and so far so good.
Thanks for the tip! Here's the problem, Apple released another POS software update!!! Getting really tired of this Apple! Nov 16, PM. Thank you so much for this answer. It worked for me and it wasn't too much trouble to add my printer back. Nov 21, AM.
What I had to do to resolve this same problem with Numbers under High Sierra was open the System Preferences, click on my printer in the "Printers" display in the left panel then remove it by clicking on the "—" button below the "Printers" display. Next time I needed to print a Numbers sheet in Landscape Orientation, my printer behaved exactly as expected, viz. Dec 1, PM. Dec 4, PM. It is also not working in Photoshop and on multiple machines which are updated from Sierra - even resetting Printing System doesn't work.
Communities Contact Support. Sign in Sign in Sign in corporate. Browse Search. Ask a question.
2. Convert Data to a Table
User profile for user: Apple Advocate Apple Advocate. Desktops Speciality level out of ten: 0.
- red dot mac miller instrumental.
- Printing an Entire excel spreadsheet as one PDF.
- Print or change page setup - Computer - Docs Editors Help.
Then hold down Shift while you click the tab for the last sheet that you want to select. Then hold down Ctrl while you click the tabs of the other sheets that you want to select. To group the worksheets, right-click any tab at the bottom of the worksheet.
On the shortcut menu, click Select All Sheets. In the title bar, you should see the name of the workbook followed by the word [Group]. Then, change the orientation to landscape or make any other customization that you want.
Printing those monster Excel sheets - Legal Office Guru
To turn off the grouping, right-click any tab, and then click Ungroup Sheets or just click another worksheet tab. Click Save As , then select the location where you want to save your worksheet. In the File name box, type the name that you want to use for the template. To use the template to create a workbook, do the following for Excel , Excel , and Excel only :.
Then hold down CTRL while you click the tabs of the other sheets that you want to select. Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.
Click the Microsoft Office Button , and then click Print. In the Print dialog box, click Properties. In the printer properties dialog box, in the Layout tab, under Orientation , click Portrait or Landscape , and click OK. The option also appears dimmed when you're in the process of editing the contents of a cell. Don't forget to ungroup the worksheets.