Suppose we have a dataset and we want to print it. But we may wish for the printed sheet to look clearer. Increasing font size helps us to read the data easily. Today we will show 2 suitable ways to increase the font size for printing in Excel. So, without any delay, let’s start the discussion.
How to Increase Font Size for Printing in Excel: 2 Suitable Ways
We have a dataset of a class. The dataset contains information on ten Student IDs, Names, and marks in Mathematics, Physics, and Chemistry. We want to print the dataset. To make the printed dataset clearer, we will increase font size. We will show 2 methods using this dataset to increase the font size for printing in Excel.
1. Apply Scaling Option to Increase Font Size for Printing in Excel
Applying the scaling option in Excel, we can easily increase the font size for printing. Here, we will use the dataset below.
Let’s follow the steps below to learn the method.
- First, from the ribbon, select the File tab.
- Now, a new window will open up.
- From the leftmost middle corner, select Print.
- After selection, the Print window will open up.
- Here we can observe various types of settings.
- A preview of the printed image is also presented here.
- From Settings, you have to click on No Scaling.
- A new dialog box will pop up.
- You need to select Custom Scaling Options to change the font size.
- After that, the Page Setup window can be seen.
- In the Scaling option, this is showing 100% of the normal size.
- That means the printed figure will be equal to the font size in Excel.
- In the next step, let’s see what is the preview of the printed figure.
- From the preview image, we can know how well the figure looks on the paper.
- From the preview image, it is clear that the font size needs to increase.
- Now change the scaling from 100% to 140% of the normal size.
- That means that the font size will be 1.4 times bigger on the printed paper.
- Press OK.
- To check the image, observe the preview in the settings.
- You can notice that the font size has become bigger.
- Now we can print.
- Finally, select your printer.
- Then, select the number of copies you want.
- In the last step, press Print, and now the printing process will start.
2. Utilize Page Break Feature to Increase Font Size for Printing in Excel
Another way to increase the font size for printing in Excel is to utilize the Page Break feature. Here, we will use the dataset below.
Let’s observe the steps below to learn the method.
- First of all, go to the right–bottom corner of the worksheet and select Page Break Preview.
- From the Page Break Preview, you can select the range to show on your printed figure.
- As our dataset is small, we can show the full dataset on a single page.
- Here Blue Border indicates the page border.
- By moving the blue border, we can change the page range.
- We have moved and adjusted the blue border for printing the whole dataset.
- Now, go to the Scale to Fit section in the Page Layout tab.
- You can see that the default scale is 100%.
- To change the scaling click on the dialog launcher icon.
- As a result, a dialog box named Page Setup will launch.
- Click Print Preview from there.
- Now from the preview, we can observe how well the dataset will look on printed paper.
- From the preview, it can be noticed that the font size is not enough for us.
- So, we need to increase the font.
- Now, return to Scale to Fit.
- Set Scale to 130% to increase the font size by 30%.
- After that, from the dialog launcher open Page Setup.
- Now, select Print Preview to observe the preview
- As a result, we can observe how well the dataset will look on printed paper.
- The font size is now increased and will be better on printed paper.
- In the following step, select your printer.
- Then, select the number of copies you want.
- Lastly, press Print and now the printing process will start.
Download Practice Workbook
To practice by yourself, download the following workbook.
In this article, we have demonstrated how to increase font size in Excel for printing. There is a practice workbook at the beginning of the article. Go ahead and give it a try. To read similar articles, check out the ExcelDemy website. Lastly, please use the comment section below to post any questions or make any suggestions you might have.
- How to Change Font in Excel to All Caps
- How to Change Font Style in Excel
- [Fixed!] Excel Default Font Is Not Changing
- How to Change Font in Excel for All Sheets
- How to Change Font Within Formula in Excel
- How to Change Font Size in Excel
- How to Lock Font in Excel
- [Solved]: Font Changes Automatically in Excel
- [Fixed!] Unable to Change Font Color in Excel