Google Sheets can have up to 5 million cells. It’s definitely overwhelming, but it can accommodate all the numbers you want to crunch and the formulas you want to use. Now, what if you need to prepare and print a report with the data and some calculations?
Spreadsheets are not only for data analysis. More often than not, you will need to present the data together with some charts and graphs in printed form.
And, in most cases, making it as legible as possible might be a challenging task. The good news is Google Sheets provides simple ways to set your print area easily.
Now, if you’ve been used to how MS Excel sets print areas, you might find how Google Sheets handles it a little different.
Google Sheets does not have the same feature as Excel to set a print area while you’re working on your spreadsheet.
You will only find print area options once you open Google Sheets’ Print settings window.
You’ve come to the right place because we’ve got you covered. Here, we’ve carefully laid out here in this guide below the steps to easily set the print area of your spreadsheet.
Now, there are about two ways to set the print area in Google Sheets.
2 Ways to Set Print Area in Google Sheets
- Setting Selected Cells as Print Area
- Setting The Current Sheet or Workbook as Print Area
Both these methods will be covered in this guide down below. At the same time, we also made sure to include some customization tips to make your print area more readable when printed.
Hopefully, you’ll find the steps outlined here relatively easy to follow, as we have created this tutorial with beginners in mind. Also, we will expound on each of the methods bit by bit to help you follow us at every step of the way.
Without any delay, let’s get on with it!