![]() Read More: How to Print Excel Sheet in A4 Size (4 Ways) Through this process, you can also print an Excel spreadsheet on multiple pages. Finally, click on the Print option to print the datasheet.Go to Custom Scaling and choose the Fit All Columns on One Page option. If you don’t scale your spreadsheet before like the previous method, you must have to do it from here. Now, the most important task we have to do is to scale our spreadsheet.Click OK to close the Page Setup dialog box and you will find the header and footer will be shown on the page.Similarly, follow the same procedure for the footer.Now, click OK to close the Header dialog box and you will find the header in the empty Header box.We wrote down our website address in the Centre Section. A new dialog box, called Header, will appear.We are using our website address as the header and footer of our dataset. Now, if it is required to add any header or footer on your dataset, you can apply it from the Header/Footer tab.For that features, you have to click on both the Horizontally and Vertically options. If you have a limited number of rows and columns to print, you can place them at the center of the page for better visualization. Additionally, you can set your custom margins size from the Margins.You can also go to the Page Setup option and can also see many advanced features.In our case, we choose Print Active Sheets > Portrait Orientation > A4 > Normal Margins.Then, set the Print Settings according to your requirement.First press Ctrl+P on your keyboard to launch the Print option.Though the process is almost similar to the previous method, we are describing this procedure step by step: In this procedure, we will use the keyboard shortcut to print our dataset. ![]() Use of Keyboard Shortcut to Print Excel Spreadsheet Read More: How to Print Excel Sheet in Full Page (7 Ways)Ģ. Thus, we can say our process has worked perfectly and we get the data on our page. Finally, click on the Print option to print the document.If you don’t have any keep the option in Microsoft Print to PDF like us. Again, click the File > Print > arrow and you will find the heading similar to the first page.Now, click on Rows to repeat at top and select Row4.A new dialog box, entitled Page Setup, will appear.To resolve this issue, go to the Page Layout tab and click on the Print Titles in the Page Setup column.Though it is not a major error, it will be tough for other readers to find any data on that page easily. We have no heading on the top of our second page. As we review all pages, we notice a problem in our spreadsheet.After completing all the settings, click on the arrow below this page, to see the full dataset and ensure all the data has perfectly set on your page.If you have more data columns you can go for the other options for getting a better outlook of your dataset. The default page size of Excel is Letter. After that, select your desired Page Size.If you have more columns or if the text size is small enough to visualize you can choose the Landscape Orientation. As we have only 9 columns we keep our page in Portrait Orientation. In the Settings option, select the first row in Print Active Sheets.Then, go to the File option and select Print.It will help us to confirm that all of our columns remain together. A bold blue line will appear around our dataset and show us the preview on the page.Now, go to the View tab and select the Page Break Preview from the Workbook View column.First of all, in the Page Layout tab go to the Scale to Fit column.The steps of this method are given below: ![]() Our dataset is in the range of cells B5:K86. ![]() In this method, we will scale up our spreadsheet from the Page Layout ribbon, and then we will be able to print our data from the Print option. Scaling Excel Spreadsheet to Print on Multiple Pages We have taken their living place, family members- adults and children, and their house type into account and show them in the report.ġ. The dataset is in the range of cells B5:K86. 3 Easy Ways to Print Excel Spreadsheet on Multiple Pagesįor describing the methods, we considered a dataset of 80 householders’ income and expenditure reports of a city.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |