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

Method 1 – Apply Scaling Option to Increase Font Size for Printing in Excel

STEPS:

  • Click on File.

  • Select Print.

  • The Print window will open up.
  • From Settings, click on No Scaling.

Apply Scaling Option to Increase Font Size for Printing in Excel

  • A new dialog box will pop up.
  • Select Custom Scaling Options to change the font size.

  • The Page Setup window will open.
  • In the Scaling option of the Page Setup, it will show 100% of the normal size.
  • This means that the printed copy will have the same font size.

  • Check in the Print Preview. The print preview image will show how the data will look when printed.

Apply Scaling Option to Increase Font Size for Printing in Excel

  • To increase the font size, you can change the scaling from 100% to 140% of the normal size.
  • The font size will be 4 times bigger on the printed paper.
  • Click OK.

  • Go to print preview. You will notice that the font size has increased.

  • Select your printer.
  • Select the number of copies you want to print.
  • Click Print.

Apply Scaling Option to Increase Font Size for Printing in Excel

Read More: How to Increase Font Size Using Keyboard in Excel


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

STEPS:

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

  • Go to the Scale to Fit section in the Page Layout
  • You can see that the default scale is 100%.
  • To change the scaling, click on the dialog launcher icon.

  • Click Print Preview on the Page Setup dialog box.

  • The Print Preview will display how the dataset will look on printed paper.

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

  • To increase the font, return to Scale to Fit.
  • Set Scale to 130% to increase the font size by 30%.

  • Open Page Setup.
  • Select Print Preview.

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

  • You will notice that the font size has increased.

  • Select your printer.
  • Select the number of copies you want to print.
  • Click Print.

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


Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!

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