Google Sheets is one of the more important parts of the Google Workspace suite. We use it for many purposes in both, business and personal avenues and thus, it can be essential to know how its ins and outs work. In this article, we will look at how you can set the permanent print area on a Google Sheet.
How to set Print Area in Google Sheets
Google Sheets and the data imprinted on them are often converted into physical copy so that it is easy to understand and distribute. If you don’t know how to set up the Print Area, then the data on Google Sheets might not be compiled very well.
By configuring the Print Area in Google Sheets as per your preference, you can choose to print everything in your workbook, a sheet, or even a few selective cells. A print area not planned well enough can result in a clumsy-looking spreadsheet that might have abrupt page breaks. Let us look at the steps you need to follow for the same.
How to set the Print Area for a selection of cells in Google Sheets
While setting up the Print Area, the primary concern is to avoid any needless space. Unfortunately for you, you have to set the Print Area on your sheet every single time.
- From the total area on the sheet, highlight the section that you want to print out. You can enter the range of the cells or use drag-and-drop
- Click on the File tab and further, select Print
- This will open the Print Preview window, with settings on the right side
- Click on the Print drop-down and select ‘Selected Cells’. Doing so will reduce the previewed print window displayed to only the cells you had just selected
When you are satisfied with the sample print shown, click on ‘Next’ and use the printer management system to send it to the printer hooked onto your computer. The subsequent settings generally involve selecting the printer of your choice and the color you want the print to come in.
How to set the Print Area to the whole sheet
Alternatively, you can configure the Print Area to include the entirety of the Google Sheet you are using. This may be done when the data in the sheet is very dense and stretches across a considerable distance. This process involves fewer steps than mentioned in the aforementioned one.
- Land on the spreadsheet that you want to print and open the Print Settings. You can do that by clicking on File > Print or by the keyboard shortcut (Ctrl+P or CMD+P)
- Make sure that in the Print section “Current Sheet” is selected and click on Print
- Hit Next, ensure that the print options are in accordance and proceed with it
How to Print the Header row in each page
Google Sheets can also be configured in a way that you are able to print the header rows on a sheet. Printing header rows can bring more meaning to your work on Google Sheets. Having headers on each page can be very helpful for items like reports.
- Click on View > Freeze. Now choose the dimensions of your header (the general case is to have 1, or maybe 2 rows as your header)
- Now, every time you go on to print a page, or multiple pages, from this spreadsheet, you’ll find the header row(s) embedded at the top of each of them
In order to proceed with printing this page, simply follow the same steps as have been told above.
How do I set print margins in Google Sheets?
Another print setting in Google Sheets is the ability to set margins for the pages you want to print. In the print menu, you’ll find an option that says margins. There, you can either resort to the default narrow or wide margins. Alternatively, you can create a margin using the “custom margins” feature.
How do I limit an area in Google Sheets?
Wanting to limit or normalize data is an ordinary demand, especially for people involved in research disciplines. Limiting data means scaling it in such a way that its mean is 0 and its standard deviation is 1. Then, by calculating the mean, the standard deviation and applying the formula, you can easily scale any data into its normalized form. The purpose of normalizing data is to gauge how sparse a dataset is from its mean.
We hope that you find this helpful.