In this article we will show you the solution of how to fit excel sheet on one page pdf, MS excel is a software program developed by Microsoft.

It is a spreadsheet based application that enable user to format, organize and calculate data with using formula and functions. Excel comes as part of Microsoft Office suite.

A file in Excel called workbook. A workbook consists of spreadsheets. User can create as much spreadsheets as required.

A spreadsheet contains rows and columns. Rows are marked alphabetically and columns are marked numerically.

Microsoft Excel is used worldwide in every kind of businesses for business analysis, people management, managing operations, performance reporting, strategic analysis etc.

You can store Excel sheet as well as excel sheet can be export to other application like Microsoft word, Microsoft powerpoint for another format.

An Excel Spread sheet can be converted to hard copy also. But excel spread sheet most of the time contain large number of rows and files. So in the time of print out it does not fit in one page.

So we will learn how to fit excel sheet in one page pdf.

Step By Step Guide On How To Fit Excel Sheet On One Page PDF :-

1. First open a new excel file.
2. Now enter data and number you need to work on.
3. Now click on the file menu.
4. Or you can also click on Page lay out menu from Toolbar.
5. And then select print titles.
6. Then press ok.
7. Next click on Page setup menu from bottom. A menu window will open.
8. Under the scaling, there is an option named ‘Adjust to’. It might be set 100% as default. So we have to change it as per our requirements. Here we are increasing it to 200%.
9. Next press OK.
10. Now for a large database the spreadsheet might not be fit in a single page. For example when we select this large file and print preview.
11. You can see in left bottom 3 pages have occurred in that case.
12. Now we have to select page set up.
13. Next select the orientation and change it to landscape if the number row is high.
14. Next click on Adjust to and reduce the percentage.
15. Now you can see the page number is only 1. If font size and other feature is allright to you then press print or change as per your requirements.
16. Next press on Microsoft print to pdf and then Print. Save the file with a name.

Conclusion :-

This is how excel sheet is fitted into one page. You can see now a large database can be fit in a standard size of page.

This feature not only help in save pages, but also it helps in well organizing the numbers for better understanding.

I hope this article on how to fit excel sheet on one page pdf helps you and the steps and method mentioned above are easy to follow and implement.