If you always print your Excel work, I am sure you have faced the issue where your printer prints multiple pages instead of a single page on some or even most occasions.
Sometimes this can be frustrating and can lead to wastage of papers as you try to figure out what to do. But do not worry, as there are simple techniques that you can use to avoid this and make sure your Excel work is printed on one page.
In the tutorial below, I will show you the different methods you can use to print only a single page of your Excel sheet.
Fitting a worksheet to fit on one page using the Page Setup method
Using the page setup option, you can shrink your Excel worksheet to fit all the data on one page. Here are the steps to follow;
1. Open your Excel file.
2. Tap on the "Page Layout tab" on the main menu ribbon.
3. In the Page Setup section, click on the small Dialog Box Launcher icon on the bottom right corner to open a dialog box.
4. In the Page Setup Dialog box, click on the Page tab.
5. Under the Scaling section, select the option 'Fit to.'
6. In the Fit to box, choose 1. On the 'page(s) wide by 1 tall part, choose1 to fit your document to print on one page.
7. Tap the "OK" button at the bottom of the Page Setup dialog box to save your changes.
Adjusting the column width and row height
You may not need the cells to be wider or taller in many cases. And since cell size is a determinant of how much data can be printed on one page, you can achieve this by resizing the width and height. After doing this, you can use the Page Layout View to know how much data will be printed on each report page. Here are steps to follow;
1. In your open Excel file, click on the View tab on the main ribbon.
2. In the Workbook Views section, click on the Page Layout option to change how your data is displayed.
3. Use the scales at the top and left of your worksheet to reduce the column width to fit the data on one page. Click and drag your mouse to reduce the size.
4. Print your data once you confirm it is on one page.
Changing the scaling to fit all rows and columns on one page for printing
You can use the Excel inbuilt feature to rescale the rows and columns in your worksheet to fit one page.
1. Click on the File tab.
2. On the given options, click on 'Print.' Here, you can also use the keyboard shortcut CTL + P
3. In the popup print window, click on the scaling option.
4. Here, you will get the following option;
- Fit All Columns on One Page
- Fit Sheet on One Page
- Fit All Rows on One Page
5. Click on any of the options to see a preview of what your data will look like in the sheet preview section on the right.
6. Print your work.