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

Get FREE Advanced Excel Exercises with Solutions!

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.

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

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

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


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


Download Practice Workbook

To practice by yourself, download the following 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

<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Sudipta Chandra Sarker
Sudipta Chandra Sarker

Sudipta Chandra Sarker, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked on the ExcelDemy project for over a year. For ExcelDemy, he has authored 42 articles and reviewed over ten articles. He is employed as a junior software developer at the moment. He aims to create various useful Microsoft Office Add-ins, extending the functionality of Office programs. His interests span Microsoft Office Suites, Data Science, VBA, VB.NET, ASP.NET, C#, Excel, and Desktop... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo