How To Set Print Area In Google Sheets? Step-By-Step Guide!

“How to set print area in Google Sheets?” This question has become common, especially among people who are jumping from Excel to Sheets for the first time! The main reason for that is that in Excel, we can save the permanent print area setting under the “Layout” in the “Menu” but the same isn’t the case with the Google Sheets. You have to configure the setting every time you print, adding to the headache of many. But let me add, this is nothing to fuss over. 

Google Sheets has become the number one tool for small businesses to assess their daily task, cost, or revenues. The ease of access and use makes it quite popular among students too, particularly those who are new to spreadsheets. 

Using Google Sheets when it comes to defining the print area and organizing the data according to the page setup, is a piece of cake. You can print selected cells or multiple sheets in the same printing session with ease if you know the correct steps. Now, let’s get you acquainted with them!

How Do You Set The Print Area In A Spreadsheet?

From printing to sharing, Google Sheets can help you with anything! It is pretty versatile when it comes to transferring data. May it be a whole worksheet or some selected cells of your choice, you can print your sheet in the way you want.  The latter is always useful when it comes to printing relevant data only while saving paper.

You can print selective cells to ensure only the data you want reaches customers or data viewers and not the whole lot of it. This data printing, whether selective or whole, is called the print area. Nevertheless, restricting or not restricting the print area, all depends on your needs.  

Now, without further ado, let’s see how to set print area in a spreadsheet!

Steps To Set Print Area To Print Selected Cells In Google Sheets

Here is a step-by-step way of setting the print area in Google Sheets for a selective range of cells only. This method will ensure that only the data you choose (select) gets printed and not your whole spreadsheet.

Let’s see how you can do that!

Step 1: Open the Google Sheets from the browser you frequently use like Chrome, Edge, or Safari. Once opened, select the spreadsheet you wish to print.

Step 2: Once you have opened the spreadsheet, look for the data till which you want to print. Suppose if you want to print data from A1 to E11 or some other cells, select the same.

Step 3: Drag your cursor from the first cell to the last cell you want your data printed and select the same.

Step 4: Once you have selected the print area, go to the print menu.

Step 5: To reach the print menu, you have to navigate your cursor to the “File” tab and then a list of sub-options will appear. The Print settings option would be somewhat at the end of these sub-options. You can also apply the shortcuts like “Ctrl + P” or “CMD + P if Mac” to open the print options.

Step 6: Once you click on the “print”, the Google Sheets page setup will open with varying settings ranging from, print, paper size, orientation, margin, scale, etc.

Step 7: In the same page setup menu, you will catch hold of Print with the default setting of “Current Sheet”. You will have to change this default setting in order to print the cells that you have selected.

Step 8: Once you click on the “Current Sheet” option, other options like “selected cells” will also appear. Select this option and then print preview to see how your selected cells will appear after being printed.

Step 9: To make sure that your sheet data is well organized and fits well when printed on paper, scale it down to “fit to width”, although it’s a default key for some instead of “normal 100%”. However, it’s good to make sure that yours stays that way.

Step 10: After you have done the required in the Sheets page setup menu proceed to the next step by clicking on the “Next” option that will appear on the top left.

Step 11: Once you proceed by clicking next, the only thing left is to select your printer in the destination and hit on the “Print” option that is present below. Once you do that, you’ll have a hard copy of your spreadsheet in a matter of seconds.

Also Read: How To Display Current Date On Google Calendar App Icon? | Easy Steps To Follow!

Steps To Set Print Area To Print A Single Google Sheet

It is rather easier to set the Print Area for a single Google Sheet! You don’t have to follow a long list of steps but keep in mind one or two! Now, let’s see how you can achieve that!

Step 1: Open the Google Sheets from the browser you frequently use like Chrome, Edge, or Safari. Once opened, select the spreadsheet you wish to print.

Step 2: Once your spreadsheet opens, directly go to “Print” settings by going to the File Menu and clicking the print option. Or you can also apply the shortcut of “CTRL + P” or “CMD + P, if Mac”.

Step 3: After you click on the Print option, your Google Sheets page setup will open with a list of options. The options like Orientation, print, scale, margin, etc will appear.

Step 4: If you want to do the necessary changes in the orientation, scale, or margin. Do it! Once you have made the necessary changes, click on Next.

Step 5: After Clicking on Next, you’ll select your printer and then hit on “Print” lying below the box. 

Step 6: Once you have hit print, your printed paper will be out in a matter of seconds!

Steps To Set Print Area To Print Multiple Google Sheets

Printing multiple sheets too isn’t as complicated as it may sound otherwise. You can set the Print area to multiple sheets in the Google Sheets page set up after you’ve navigated your way through the same and Voila, a hard copy of multiple sheets on the way! Let’s see step by step way in which you can do the same!

Step 1: Open the Google Sheets from the browser you frequently use like Chrome, Edge, or Safari. Once opened, select the spreadsheet you wish to print.

Step 2: Once your spreadsheet opens, directly go to “Print” settings by going to the File Menu and clicking the print option. Or you can also apply the shortcut of “CTRL + P” or “CMD + P, if Mac”.

Step 3: After you click on the Print option, your Google Sheets page setup will open with a list of options. The options like Orientation, print, scale, margin, etc will appear.

Step 4: In such options, you have to go to the first one that says “Print | Current Sheet”. Here, change the option of the Current sheet to “Workbook”.

Step 5: After you select the “workbook” option, all of your Google Sheets containing multiple sheets will be selected as the print area.

Step 6: After your Print area is set to “workbook”, you can make other changes in orientation according to your needs.

Step 7: After making the necessary changes, hit on the “Next” button on the top left and proceed to print your sheet on the printer of your OS.

Step 8: Once you hit the Print button, at last, you’ll have your printed sheet in your hands in a matter of seconds!

After following these easy steps, you can conveniently print multiple sheets in one printing session! However, can you print multiple sheets on one page in Google Sheets? Let’s see!

How To Print Multiple Sheets On One Page In Google Sheets?

You can not print multiple sheets on one page in Google Sheets. Many people are wondering about this question which makes it important to address! You have to keep in mind that even though you change your print area to “workbook” and even if you scale down your sheet to “fit to page”, you still won’t have multiple sheets on a single piece of paper!

How To Add Header Row In All Printing Pages?

To make data viewing and analyzing easier, it is good to add a header row to all the printing pages. Here are the steps by which you can do the same!

1. Go to the ribbon and click on the “View” option.
2. Select the Freeze option and then select the row with the heading. Usually it is the first row and hence, select the same.
3. After you do that and follow the next few steps of printing your sheet, you’ll see that the header row will appear on every page that you printed! 

Freezing header rows is highly convenient if you frequently use Google Sheets. So if you never knew you could do that, do try it out in your next Sheet session!

Also Read: How To Delete Browsing History In Google Chrome

How To Set Print Area In Google Sheets To Print On One Page?

Many times, our printed data spills on the next page which is just a waste of paper. In such situations, we try to print data that fits on one page alone. As we’re talking about Google Sheets here, let’s see how you can remedy such situations there!

To print Google Sheets on one page, the process is rather simple. The answer to “One page” that people usually ask actually lies in the Google Sheets page setup menu alone. Once you go ahead with your printing session, you have to pay close attention to “scaling down” your sheet. 

Let’s see how you can do that!

Step 1: Choose the dataset or number of cells you want to print and highlight it by dragging down your cursor.

Step 2: After selecting the dataset, click on the print settings from the ribbon or use shortcuts like “CTRL + P” or “CMD + P, if Mac”.

Step 3: After clicking on the print option, a Google Sheets Page Setup box will appear with numerous options.

Step 4: On the same menu, you have to click on the option that reads “Scale | Fit to width”.

Step 5: Change the “Fit to width or Normal 100%” option to “ Fit to page”.

Step 6: Once you scale down your sheet to “Fit to page”, the whole of your Google Sheet will appear on one page. 

Step 7: Go to next, select the printer and click on “Print” at last. This way, you’ll have your selected dataset on one sheet of paper alone.

Also Read: How to Draw on Google Docs | Simple Google Hacks

Wrapping Up:

Google Suite has given us free, easy-to-use programs like Google Sheets which has made our professional lives easier. In a professional environment, we need to be well-versed in programs (like Sheets, for example) to show our competency, but if we get stuck in the basics, then we’re basically doomed in the eyes of our fellow colleagues! 

If you’re ever asked to or want to get a printout of a selected dataset in your sheet, what will you do? The answer is quite easy here! You’ll simply have to restrict your print area by selecting the cells you want to print and then hitting on the print option! Other steps are quite easy to follow!

I hope this session on “Google Sheets Print Area” and “Printing” in general helped in getting rid of your doubts!

Frequently Asked Questions