Printing an Excel sheet in landscape orientation or a long size full page can be a bit challenging, especially if you're not familiar with the various printing options. However, with a few tweaks in your printer settings and Excel's print layout, you can achieve your desired print format. Here's a step-by-step guide on how to print an Excel sheet in landscape size, full page.
Before you begin, ensure that your Excel sheet is correctly formatted. If your data is too wide to fit on a single page, consider collapsing some columns, reducing the font size, or removing unnecessary data. This will help you achieve the best print format.
Preparing Your Excel Sheet for Printing
Before printing, you need to ensure that your Excel sheet is set up correctly to print in landscape mode and fit the entire page.
First, select the cells you want to print. If you want to print the entire worksheet, press Ctrl+A (Windows) or Command+A (Mac) to select all cells. Then, click on File > Print to open the Print dialog box.
Changing the Print Orientation
In the Print dialog box, look for the Settings section. Here, you'll see options for print orientation. Click on the dropdown menu and select Landscape. This will rotate your print view 90 degrees, allowing your Excel sheet to fit the width of the paper.
However, if your data is still not fitting the page, you might need to adjust the scale or use a custom scale to ensure your data prints on as few pages as possible.
Adjusting the Print Scale
Below the print orientation options, you'll see a section for Page size and scaling. The default setting for scaling is 'Fit to page'. This option scales your data to fit within the margins of the selected page size. If your data is still not fitting, you can select 'Custom scale', which allows you to adjust the scaling percentage to fit your data on the full page.
For instance, if you want to print your Excel sheet at 50% scale, enter 50 in the Custom scale field. This will reduce the size of your data, allowing it to fit on a single page.
Adjusting Excel's Print Area
Sometimes, you might want to print a specific range of cells in your Excel sheet. You can set a custom print area to focus on that range.
To do this, select the range of cells you want to print, and then click on File > Print. In the Print dialog box, under Settings, you'll see a section for Print range. Here, you can type the range of cells you want to print, such as A1:C20. Click OK to start printing.
Printing a Specific Sheet
If your Excel file contains multiple worksheets, and you only want to print one, you can select the specific sheet you want to print. In the Print dialog box, under Settings, you'll see a dropdown menu for Print what. Select the sheet you want to print from the list.
Remember, if your data doesn't fit the page or looks distorted, you can adjust the print scale or use the landscape mode to get the desired output.
Printing an Excel sheet in landscape size, full page might seem complicated at first, but with these steps, you'll be able to achieve the perfect print format every time. Keep experimenting with the print layout and settings until you get the printout just right.