Sometimes you may need to print out your data. In that case, you may need to stretch an Excel spreadsheet to full-page print. In this article, I will explain how to stretch an Excel spreadsheet to full-page print.
Download Practice Workbook
You can download the practice workbook from here:
5 Methods to Stretch Excel Spreadsheet to Full Page Print
Here, I will describe 5 methods to stretch an Excel spreadsheet to full-page print. In addition, for your better understanding, I’m going to use a sample data set. Which contains 6 columns. They are Student ID, Subject, CQ(60), MCQ(40), Total Marks, and Grade.
1. Using Scale to Fit Group to Stretch Excel Spreadsheet to Full Page Print
You can use the Scale to Fit group to stretch an Excel spreadsheet to full-page print. The steps are given below.
Steps:
- Firstly, you have to open your worksheet.
- Secondly, from the Page Layout ribbon >> you need to change the Width and Height to 1 page, which is under Scale to Fit group. Here you can also use Excel keyboard shortcuts ALT+P to go to the Page Layout ribbon.
- Here, based on the dataset of the sheet the value of Scale will auto-update.
- Thirdly, you must Click on the Drop-Down Arrow.
At this time, a dialog box named Page Setup will appear.
- Now, you need to select the Print Preview option from that Page Setup dialog box.
After that, you will see the following page layout with your data. But, at this stage, there may be white space in your previewed copy. Here, you can see my previewed page has some white space below. So, you have to change the row height or column width to spread your data over the whole page.
- Now, you need to go back to the worksheet by clicking on the Go Back Arrow.
Here, I will change the Row Height.
- Firstly, you have to select your data.
- Secondly, you need to go to the Home tab.
- Thirdly, from the Cells option >> you have to choose the Format command.
- Finally, you must select the Row Height option.
At this time, a dialog box named Row Height will appear.
- Now, you have to write down the preferred Row height. Here, I have written 40 as Row height.
- Then, you must press OK to make the changes.
Below, you will see the changed Row height. Here, I have also changed the width of the Columns.
- Now, to see the print preview, from the Page Layout tab >> you have to select the Drop-Down Arrow.
At this time, the dialog box named Page Setup will appear again.
- Now, you need to select the Print Preview option from that Page Setup dialog box.
Finally, you can see the stretched Excel spreadsheet to full page print.
Furthermore, you may think that some of the data may be cropped in the above image. But, if you print out your page then you will see a clear image of your all data as you set them. For your better understanding, I have included a zoomed image of the print copy.
Read More: How to Fit to Page in Excel (3 Easy Ways)
2. Applying Margins Feature to Stretch Excel Spreadsheet to Full Page Print
You can apply the Margins feature to stretch an Excel spreadsheet to full-page print. The steps are given below.
Steps:
- Firstly, you have to open your worksheet.
- Secondly, from the Page Layout ribbon >> you have to go to the Drop-Down Arrow.
At this time, a dialog box named Page Setup will appear.
- Now, you need to select the Margins option from that Page Setup dialog box.
- Then, from the Margins >> you need to tick mark on the Horizontally and Vertically options.
- Now, you have to go to the Page command in the Page Setup dialog box.
- Then, you must click on the Fit to option.
- Finally, go to the Print Preview option to see the image of the printed copy.
Subsequently, you will see the print previewed copy.
- Now, you can change the Margins option from Normal to Narrow to set your data within the full page.
Finally, you will get the stretched Excel spreadsheet to full-page print.
Read More: How to Adjust Page Size for Printing in Excel (6 Quick Tricks)
3. Employing Orientation Command
You can employ the Orientation Command to stretch an Excel spreadsheet to full-page print. The steps are given below.
Steps:
- Firstly, you have to open your worksheet.
- Secondly, from the Page Layout ribbon >> go to Orientation command >> Then, you can choose the Landscape option.
- Thirdly, you have to go to the Drop-Down Arrow.
At this time, a dialog box named Page Setup will appear.
- Now, you have to go to the Page command in the Page Setup dialog box.
- Then, you must click on the Fit to option.
- Now, from the Sheet command in the Page Setup dialog box >> you have to go to Drop-Down Arrow which is adjacent to the Print area.
- At this time, you need to select the data up to which you want to print them. Here, I have selected the data range B2:G25.
- Then, you must click on the Drop-Down Arrow to go back to the whole Page Setup dialog box.
- Finally, you must select the Print Preview option to see the image of the printed copy.
Last but not the least, you can see the print previewed copy.
- Again, go back to the worksheet.
- Then, I extended some columns’ width and rows’ height to fill the blank space of the printed copy.
- Now, from the Page Layout ribbon >> you have to go to the Drop-Down Arrow to open the Page Setup dialog box.
- Then, from that dialog box, select the Print Preview option to see the changes I have made.
Finally, you can see the stretched Excel spreadsheet to full page print.
Read More: How to Fit All Columns on One Page in Excel (5 Easy Methods)
4. Using Page Size Feature to Stretch Excel Spreadsheet to Full Page Print
You can change the page size to stretch an Excel spreadsheet to a full page print. Basically, you can use the Page Size feature to change the page size. The steps are given below.
Steps:
- Firstly, you have to open your worksheet.
- Secondly, from the Page Layout ribbon >> you have to go to the Size command >> Then, you can choose according to your preference from the page size options. Here, I have chosen A4.
- Thirdly, you need to press the Drop-Down Arrow.
At this time, a dialog box named Page Setup will appear.
- Now, you have to go to the Page command in the Page Setup dialog box.
- Then, you must click on the Fit to option.
- After that, press the Print Preview option to see the print previewed copy.
Here, you will see the Print copy. Which has still some white space below.
Here, I will change the Row Height.
- Firstly, you have to select your data.
- Secondly, you need to go to the Home tab.
- Thirdly, from the Cells option >> you have to choose the Format command.
- Finally, you must select the Row Height option.
At this time, a dialog box named Row Height will appear.
- Now, you have to write down the preferred Row height. Here, I have written 35 as the Row height.
- Then, you must press OK to make the changes.
Subsequently, you will see the changes.
- Now, from the Page Layout ribbon >> you have to go to the Drop-Down Arrow to open the Page Setup dialog box.
- Then, from the dialog box named Page Setup, select the Print Preview option to see the changes I have made.
Finally, you can see the stretched Excel spreadsheet to full page print.
Read More: How to Change the Printing Scale So All Columns Will Print on a Single Page
5. Use of Print Area Command to Stretch an Excel Spreadsheet to Full Page Print
You can use the Print Area Command to stretch an Excel spreadsheet to full-page print. The steps are given below.
Steps:
- Firstly, you have to open your worksheet.
- Secondly, select the data. Here, I have selected the range B2:G25.
- Thirdly, from the Page Layout ribbon >> you need to go to the Print Area command >> Then, you have to choose Set Print Area.
- Finally, you must Click on the Drop-Down Arrow.
At this time, a dialog box named Page Setup will appear.
- Now, you have to go to the Page command in the Page Setup dialog box.
- Then, you must click on the Fit to option.
- Finally, press the Print Preview option.
After that, you will see the following page layout with your data. But, at this stage, there may be white space in your previewed copy. Here, you can see my previewed page has some white space below. So, you have to change the row height or column width to spread your data over the full page.
Here, you can follow the changing Row height part of the method-1. After that, finally, you will get the stretched Excel spreadsheet to full-page print.
Read More: Excel Fit to Page Scale/Preview Looks Small (5 Suitable Solutions)
💬 Things to Remember
- You don’t need to go to the worksheet again and again. In addition, some options are been in the Print feature. So, you can use them too.
- Furthermore, you should always select the Print Area. This command will automatically remove some extra white spaces.
Conclusion
I hope you found this article helpful. Here, I have explained 5 methods of How to Stretch an Excel Spreadsheet to Full Page Print. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
Related Articles
- Fit Excel Sheet on One Page in Word (3 Simple Ways)
- How to Add Legal Paper Size in Excel
- Why Is My Excel Sheet Printing So Small (Reasons and Solutions)
- How to Add A3 Paper Size in Excel (2 Quick Ways)
