Microsoft Excel is an amazing software which importance can’t be explained in words. It is very essential part of almost every institutions. To have the work in Excel, we sometimes need hard copy. For this, we need to print the worksheet. In this article, I am going to explain 5 simple ways to print full page of Excel sheet in A4 size.
For more clarification, I am going to use a dataset of a company’s employee information in the Employee ID, Name, Gender, Department, and State columns.
5 Simple Ways to Print Full Page of Excel Sheet in A4 Size
1. Defining Size from Page Layout Tab
Defining size from the Page Layout tab is a very easy way to convert the sheet in A4 for printing. Then, you can simply print the full page in A4 size.
Steps:
- Firstly, click on the Page Layout tab.
- Then, choose the Size option from the ribbon.
- Pick the A4 option from the available options.
- Then, press CTRL + P or go to the Print option from the File tab.
Thus, we will have a Print Preview of full page in A4 size.
Read More: How to Add A3 Paper Size in Excel (2 Quick Ways)
2. Utilizing Page Setup Option from Page Layout Tab
We can utilize the Page Setup option from the Page Layout tab to print full page in A4 size.
Steps:
- Go to the Page Layout tab.
- Click on the Page Setup group’s button from the ribbon.
A Page Setup wizard will appear.
- Check the Fit to box from the Scaling option.
- Input 1 in page(s) wide by box and 1 in tall box to define length and width ratio.
- Choose A4 from the Paper size option.
- Then, click on Print Preview to verify the given command.
From the preview, we can see that the full page is ready to be printed in A4 size.
Read More: How to Add Legal Paper Size in Excel
Similar Readings
- Fit All Columns on One Page in Excel (5 Easy Methods)
- How to Change the Printing Scale So All Columns Will Print on a Single Page
- Why Is My Excel Sheet Printing So Small (Reasons and Solutions)
- Excel Fit to Page Scale/Preview Looks Small (5 Suitable Solutions)
3. Fixing Page Size from Print Preview Window
Another effective way to print full page in A4 size is to fix the page size from Print Preview window.
Steps:
- Go to the File tab.
- Then, click on the Print option to have the Print Preview.
Alternatively, you can just simply press CTRL + P to have the Print Preview window.
- Click on the selected box from the Settings to define page size.
- Choose A4 option.
This is how we can print a full page Excel sheet in A4 size.
Read More: How to Add Paper Size in Excel (4 Easy Ways)
4. Changing Scaling to Print Full Page in A4 Size
Sometimes we might face problems adjusting a big dataset in a single page. In that case, we can change Scaling to print full page of Excel sheet in A4 size.
To explain it, I have created a detailed dataset with additional the Height, Weight, Street Address, City columns.
Steps:
- Press CTRL + P to have the Print Preview window.
- From the Settings option, input Landscape Orientation, A4, and Fit Sheet in One Page commands.
This is another way how we can print a full page Excel sheet in A4 size.
Read More: How to Adjust Page Size for Printing in Excel (6 Quick Tricks)
5. Fixing Row and Height Manually to Print Full Page in A4 Size
For a very wide dataset with many columns, we can manually fix the rows and columns to fit them in a single A4 size.
For this, I have gathered an extended dataset.
Steps:
- Press CTRL + P to have the Print Preview window.
From the Print Preview, we can see that the dataset does not fit in one page.
- Next, shorten the cell width and extend the cell height with cursor to fit it in a single page.
This process can also be applied to print full page in A4 size.
Read More: How to Stretch Excel Spreadsheet to Full Page Print (5 Easy Ways)
Practice Section
For more expertise, you can practice here.
Conclusion
That’s all for the article. In this article, I have tried to elaborate on 5 simple ways to print full page of Excel sheet in A4 size. It will be a great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for more details on Excel.
Related Articles
- [Solved!] Print Scale to Fit Not Working in Excel
- How to Fit Excel Sheet on One Page PDF (8 Simple Ways)
- Fit to Page in Excel (3 Easy Ways)
- How to Fit Excel Sheet on One Page in Word (3 Simple Ways)