How to Print Bigger in Google Sheets: 2 Easy Methods

Have you ever wanted to make your Google Sheets printouts larger? Printing in a larger font can greatly enhance the usefulness, accessibility, and readability of your spreadsheet. It allows you to highlight important information and make your sheet more attractive and polished. In this article, I will show you two simple methods to print bigger in Google Sheets. Let’s dive in!

Method 1: Print the Entire Sheet Larger

Let’s say you want to print the entire dataset or sheet in a larger font. Zooming in on the sheet won’t increase the print size. To print the entire sheet larger, follow these steps:

1. First, go to the File tab in the top menu bar and select Print to access the print settings.
2. Alternatively, you can press Ctrl+P.
3. The Print settings window will appear. Then, go to the drop-down list in the Scale section.

4. Choose the Custom number option from the drop-down list.
5. In the Percentage section, select a zoom percentage for your dataset. For example, let’s choose a 200% zoom. Then, click Next to print the dataset with a 200% zoom.
6. Finally, press Print to get a larger printed copy.

Method 2: Print a Selected Cell Range Larger

In Google Sheets, you can also choose a specific range of cells to print. This is especially useful when working with large datasets and you only want to print a selected range of cells. Follow these steps:

1. First, select the range of cells you want to print. In our case, let’s select Cells B4:C11. Then, click the Print icon in the top menu bar to access the print settings.

2. The Print settings window will appear.
3. In the Print section, choose Selected cells (B4:C11) to print only the selected cells.
4. In the Scale section, choose the Custom number option to zoom in on the print layout. Select a zoom percentage according to your preferences. In our case, let’s choose a 350% zoom.
5. Finally, click Next to print the selected cells with a 350% zoom.

How to Print with Gridlines in Google Sheets

Sometimes, you may want to print your dataset with gridlines visible. However, when you access the print settings, the gridlines may disappear from the dataset. In that case, you need to modify the formatting in the print settings. Here’s how:

1. Click the Print icon in the top menu bar to access the print settings.
2. Alternatively, you can press Ctrl+P.
3. The Print settings window will appear. Then, click the drop-down icon in the Formatting section.

4. Click the Show gridlines option to print the dataset with gridlines visible. Then, click Next to print the dataset with gridlines.

By following these steps, you’ll be able to print your Google Sheets in a larger font size and even include gridlines for better readability.

Conclusion

That’s it for this article! By adjusting the scale in the print settings, you can print the entire sheet or a selected cell range in a larger font size. If you have any comments, suggestions, or questions, feel free to leave them in the section below. And remember, for more useful articles on Google Sheets, explore our website Crawlan.com.

Stay tuned for more tips and tricks on how to make the most out of Google Sheets! Happy printing!