How to change worksheet size in Excel

Excel has settings for you to resize the spreadsheet, adjusting it to display all columns and rows on the same page. Or if needed, users can also adjust the number of printed pages displayed for preview before printing.

For worksheets with a large number of rows and columns, this resizing operation helps you a lot, without having to scroll to the position you need to view. Below are instructions for resizing Excel spreadsheets.

How to resize an Excel spreadsheet to fit the width

For Excel documents that need to be printed, you can adjust the width of the spreadsheet to fit the width of the printed page.

Step 1:

At the Excel interface, click on the Page Layout tab above, then below at Width , click on the arrow to expand the list of options.

How to change worksheet size in Excel Picture 1How to change worksheet size in Excel Picture 1

Next, you adjust the mode to 1 page .

How to change worksheet size in Excel Picture 2How to change worksheet size in Excel Picture 2

 

Step 2:

Continuing at Orientation , we switch to Landscape mode to print horizontally if desired

Your spreadsheet will be scaled so that all columns fit on a single sheet.

How to change worksheet size in Excel Picture 3How to change worksheet size in Excel Picture 3

How to adjust Excel spreadsheet to fit horizontally

We will adjust the spreadsheet so that all rows fit on the printed page.

You also click on the Page Layout tab , then below at Height we also select 1 Page in the displayed list.

We can leave Width as Automatic.

How to change worksheet size in Excel Picture 4How to change worksheet size in Excel Picture 4

If you want your spreadsheet to fit on a single page in Print settings, click File then Print to make adjustments.

How to change worksheet size in Excel Picture 5How to change worksheet size in Excel Picture 5

 

In Custom Scaling , click on Fit All Rows on One Page .

How to change worksheet size in Excel Picture 6How to change worksheet size in Excel Picture 6

How to edit Excel spreadsheet in 1 page

You can also adjust the Excel worksheet so that the entire content fits on one page. Then all rows and columns will display on one page when printing the document. However, you should note that if the data table has a large number of columns and rows, Excel automatically adjusts the cells in the table to make them smaller.

We click on Page Layout then adjust Width to 1 page and Height to 1 page . Thus, the spreadsheet will adjust the data table to fit the width and width of one page. Then you can adjust the page to print horizontally or vertically if you want.

How to change worksheet size in Excel Picture 7How to change worksheet size in Excel Picture 7

We can also adjust in Print settings by pressing Fit Sheet on One Page in Scaling Options.

How to change worksheet size in Excel Picture 8How to change worksheet size in Excel Picture 8

 

How to resize an Excel spreadsheet into multiple pages

For example, when you adjust an Excel spreadsheet in 1 page but the data cells are too small. Then you want to adjust the Excel spreadsheet with width and width in 2 pages to make it easier to see the data.

We click on Page Layout and then adjust Width and Height for the height and width of the sheet according to the number of pages you want, for example to fit 2 sheets.

How to change worksheet size in Excel Picture 9How to change worksheet size in Excel Picture 9

Thus the size of the cell in the table is not shrunk too much.

You can also adjust it in Print settings. At Scaling, click Custom Scaling Options to adjust.

How to change worksheet size in Excel Picture 10How to change worksheet size in Excel Picture 10

In the new interface, users click Fit To and then enter the number of pages in both width and height you want the Excel spreadsheet size to fit that number of pages.

How to change worksheet size in Excel Picture 11How to change worksheet size in Excel Picture 11

Instructions for adjusting the scale of Excel spreadsheets

Step 1:

Click on the Page Layout tab and then choose to look down at the Page Setup group . Click on the arrow icon to open the custom interface.

How to change worksheet size in Excel Picture 12How to change worksheet size in Excel Picture 12

 

Step 2:

To customize the new interface, select Adjust To then adjust the percentage to adjust the appropriate sheet ratio.

How to change worksheet size in Excel Picture 13How to change worksheet size in Excel Picture 13

4 ★ | 1 Vote