Excel Tutorial: How To Make An Excel Spreadsheet Print Larger


Do you find yourself squinting at your computer screen trying to read the small print on your Excel spreadsheet? You're not alone. Many users struggle with this issue, especially when trying to print out their spreadsheets for reference. It's important to address this problem as it can cause unnecessary strain on your eyes and hinder your productivity. In this tutorial, we will show you how to make an Excel spreadsheet print larger so that you can easily read and reference your data without any hassle.

Key Takeaways

  • Addressing small print in Excel spreadsheets is important to reduce eye strain and improve productivity.
  • Adjusting print settings, changing font size and style, using the zoom feature, and utilizing print preview can all help make Excel spreadsheets print larger and more readable.
  • Consider using a larger paper size, such as A3 or legal, to accommodate larger prints in Excel.
  • It's essential to navigate through the different pages in print preview and make additional adjustments if needed to ensure readability.
  • By following the outlined methods, users can ensure that their Excel spreadsheets are legible and easy to reference, improving overall usability.

Adjusting print settings in Excel

When working with Excel, it’s important to ensure that your spreadsheet prints in a legible and visually appealing manner. Adjusting the print settings in Excel allows you to control the size and layout of your spreadsheet when it is printed.

A. Accessing the Page Layout tab
  • Step 1:

    Open your Excel spreadsheet and click on the Page Layout tab at the top of the Excel window.
  • Step 2:

    This will open a range of options for adjusting the print settings of your spreadsheet.

B. Modifying the margins and scaling options
  • Step 1:

    In the Page Layout tab, you can click on the Margins button to adjust the margins of your spreadsheet, ensuring that there is enough space around the edges when printed.
  • Step 2:

    You can also click on the Scale to Fit button to adjust the scaling options, allowing you to make your spreadsheet larger or smaller when printed.

C. Previewing the changes before printing
  • Step 1:

    After making adjustments to the margins and scaling options, you can preview how your spreadsheet will look when printed by clicking on the Print Preview button in the Page Layout tab.
  • Step 2:

    This will give you a visual representation of how your spreadsheet will appear on paper, allowing you to make any additional adjustments if necessary.

Changing the font size and style

When working with an Excel spreadsheet, it's important to ensure that the content is easily readable when printed. One way to achieve this is by adjusting the font size and style to make it larger and more legible.

A. Selecting all cells in the spreadsheet
  • To begin, open the Excel spreadsheet that you want to print with a larger font size.
  • Click on the top left corner of the spreadsheet to select all the cells. You can also use the shortcut Ctrl + A to select all the cells.

B. Choosing a larger font size and changing the font style
  • With all the cells selected, navigate to the "Home" tab in the Excel ribbon.
  • In the "Font" section, you can increase the font size by selecting a larger number from the dropdown menu.
  • You can also change the font style by choosing a different font from the dropdown menu in the "Font" section.

C. Adjusting column width if necessary
  • After changing the font size and style, you may need to adjust the column width to ensure that the text fits properly within the cells.
  • To do this, hover your cursor over the line between two column headers until it turns into a double-sided arrow, then click and drag to adjust the width as needed.

Using the zoom feature

When working with Excel, it is often necessary to adjust the size of the spreadsheet for better visibility. One way to make an Excel spreadsheet print larger is by using the zoom feature.

A. Locating the zoom slider on the bottom right corner of the window

To locate the zoom slider, look for it in the bottom right corner of the Excel window. It is represented by a percentage value with a sliding bar that you can adjust.

B. Increasing the zoom percentage to make the spreadsheet larger

To make the spreadsheet appear larger when printed, simply slide the zoom bar to the right to increase the zoom percentage. This will make the cells, text, and images in the spreadsheet appear larger on the screen and when printed.

C. Saving the zoom setting for future use

Once you have adjusted the zoom percentage to your desired size, you can save this setting for future use. This can be done by going to the "View" tab and selecting "Zoom" and then "100%" to set the zoom percentage as the default for the workbook. This way, every time you open the workbook, the zoom percentage will be set to your preferred size.

Utilizing the print preview feature

When it comes to printing an Excel spreadsheet, ensuring that it prints out in a larger font size for better readability is crucial. One of the most effective ways to achieve this is by utilizing the print preview feature within Excel.

A. Accessing the print preview option in Excel

To access the print preview feature in Excel, simply click on the "File" tab at the top-left corner of the Excel window. From the drop-down menu, select "Print" to enter the print preview mode.

B. Navigating through the different pages to ensure readability

Once in the print preview mode, navigate through the different pages of the spreadsheet to ensure that the content is easily readable. This allows you to assess the font size and overall appearance of the printed spreadsheet.

C. Making additional adjustments if needed

If the font size or overall appearance of the spreadsheet in the print preview mode is not satisfactory, you can make additional adjustments. This can include modifying the page layout, adjusting the margins, or changing the scaling of the content to better fit the printed page.

Considering the use of a larger paper size

When it comes to making an excel spreadsheet print larger, one option to consider is using a larger paper size such as A3 or legal paper. This can be especially useful when dealing with complex or detailed data that may benefit from a larger print format.

  • Exploring the option to print on A3 or legal paper
  • First, you'll want to check if your printer supports A3 or legal paper sizes. These larger paper sizes can accommodate more data on a single page and make it easier to view and analyze the information.

  • Adjusting the page setup to accommodate the larger paper size
  • Once you've confirmed that your printer can handle A3 or legal paper, you'll need to adjust the page setup in your excel spreadsheet. This includes changing the paper size settings to match the larger paper size you plan to use.

  • Ensuring printer compatibility
  • It's important to ensure that your printer is compatible with the larger paper size you plan to use. Some printers may require specific tray settings or adjustments to accommodate A3 or legal paper, so be sure to check the printer's specifications and settings.


In conclusion, this tutorial has provided key points for making an Excel spreadsheet print larger. Ensuring that your spreadsheet is legible and easy to read is crucial for effective communication of data. By utilizing the methods outlined in this tutorial, you can improve the readability of your Excel spreadsheets and enhance the overall presentation of your data. We strongly encourage our readers to implement these techniques for larger prints in Excel and see the difference it makes in their professional documents.

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles