It reduces the size of fonts and other objects on the page until they are small enough to fit the space allocated on the paper.
autofitting
The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.The amount of pages created depends on the amount of data that is in the worksheet. A small worksheet will fit on one printed page. Larger sheets will spill onto more than one page. It is possible to rescale a page or adjust margins or set page breaks, so you can change the way Excel creates printed pages.
well go to print preview then options then print 5 pages in one paper
In Excel, the options allow you to adjust your print output, as desired. The most helpful option is to let Excel automatically scale your spreadsheet to fit on a single printed page.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.It will adjust the size while keeping the correct scale so that the page can fit on a printed page.
An A4 page is too large to fit into an A5 page, as A4 is twice as large than A5. An A5 page would fit into an A4 page twice.
Print Preview in Excel allows you to see how your worksheet will look when it is printed. So it would show a page and what will fit on it. The data may be on several pages and this would be shown in the Print Preview, so you could see what appears on each page without actually printing it. This can allow you to change the document and move some data so it appears on a different page.
close fit
Page Layout gives a number of options for sizing a worksheet to the desired output. The feature most appropriate for what I believe your question is asking is Page Layout, Page Setup, Page, Scaling. Then you decide how many pages "tall" and how many pages "wide" you want and it does the rest.
Double click on a column, and it will automatically make the column wide enough to fit the longest entry.