![]() Finally, you must select the Print Preview option to see the image of the printed copy.Then, you must click on the Drop-Down Arrow to go back to the whole Page Setup dialog box.Here, I have selected the data range B2:G25. At this time, you need to select the data up to which you want to print them.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.Thirdly, you have to go to the Drop-Down Arrow.Secondly, from the Page Layout ribbon > go to Orientation command > Then, you can choose the Landscape option.You can employ the Orientation Command to stretch an Excel spreadsheet to full-page print. Read More: How to Adjust Page Size for Printing in Excel (6 Quick Tricks) Now, you can change the Margins option from Normal to Narrow to set your data within the full page.įinally, you will get the stretched Excel spreadsheet to full-page print.Subsequently, you will see the print previewed copy. Finally, go to the Print Preview option to see the image of the printed copy.Then, you must click on the Fit to option.Now, you have to go to the Page command in the Page Setup dialog box.Then, from the Margins > you need to tick mark on the Horizontally and Vertically options.Now, you need to select the Margins option from that Page Setup dialog box.Secondly, from the Page Layout ribbon > you have to go to the Drop-Down Arrow.You can apply the Margins feature to stretch an Excel spreadsheet to full-page print. Applying Margins Feature to Stretch Excel Spreadsheet to Full Page Print Read More: How to Fit to Page in Excel (3 Easy Ways)Ģ. For your better understanding, I have included a zoomed image of the print copy. But, if you print out your page then you will see a clear image of your all data as you set them. Now, to see the print preview, from the Page Layout tab > you have to select the Drop-Down Arrow.Īt this time, the dialog box named Page Setup will appear again.įinally, you can see the stretched Excel spreadsheet to full page print.įurthermore, you may think that some of the data may be cropped in the above image.Here, I have also changed the width of the Columns. Then, you must press OK to make the changes.īelow, you will see the changed Row height.Now, you have to write down the preferred Row height.Finally, you must select the Row Height option.Īt this time, a dialog box named Row Height will appear.Thirdly, from the Cells option > you have to choose the Format command.Secondly, you need to go to the Home tab.Now, you need to go back to the worksheet by clicking on the Go Back Arrow.So, you have to change the row height or column width to spread your data over the whole page. Here, you can see my previewed page has some white space below. But, at this stage, there may be white space in your previewed copy. Now, you need to select the Print Preview option from that Page Setup dialog box.Īfter that, you will see the following page layout with your data.Thirdly, you must Click on the Drop-Down Arrow.Īt this time, a dialog box named Page Setup will appear.Here, based on the dataset of the sheet the value of Scale will auto-update. ![]() Here you can also use Excel keyboard shortcuts ALT+P to go to the Page Layout ribbon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |