How to Increase Font Size for Printing in Excel (2 Suitable Ways)

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.


Download Practice Workbook

To practice by yourself, download the following workbook.


2 Suitable Ways to Increase Font Size for Printing in Excel

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.

how to increase font size in excel for printing


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.

Apply Scaling Option to Increase Font Size for Printing in Excel

Let’s follow the steps below to learn the method.

STEPS:

  • 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.

Apply Scaling Option to Increase Font Size for Printing in Excel

  • 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.

Apply Scaling Option to Increase Font Size for Printing in Excel

  • 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.

Apply Scaling Option to Increase Font Size for Printing in Excel

Read More: How to Increase Font Size Using Keyboard in Excel (3 Easy Ways)


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.

Utilize Page Break Feature to Increase Font Size for Printing in Excel

Let’s observe the steps below to learn the method.

STEPS:

  • First of all, go to the rightbottom 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.

Utilize Page Break Feature to Increase Font Size for Printing in Excel

  • 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 lunch.
  • Click Print Preview from there.

  • Now from the preview, we can observe how well the dataset will look on printed paper.

Utilize Page Break Feature to Increase Font Size for Printing in Excel

  • 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

Utilize Page Break Feature to Increase Font Size for Printing in Excel

  • 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.

Utilize Page Break Feature to Increase Font Size for Printing in Excel

Read More: How to Change Default Font in Existing Excel Workbook


Conclusion

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.


Related Articles

Tags:

Sudipta Chandra Sarker

Sudipta Chandra Sarker

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology-Bangladesh. I have a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo