The steps discussed here should work on all mobile versions of Google Sheets. However, you can still change the print settings, including the paper size, the specific pages you wish to print, and the color and paper orientation. There is one downside as you can not set print area on Google Sheets mobile. If you use Google Sheets on mobile, you can print your spreadsheet, similar to how you can do it on Google Sheets for desktop. One of the best things about using Google Sheets is that it saves your progress on the cloud, meaning you can access your spreadsheets on virtually any device with a browser and an internet connection. How Do I Set Print Area in Google Sheets on Mobile Select your desired options and then click on Print. This will open your browser’s print menu.Feel free to insert page breaks if the data exceeds the page limit. You will see the data in the Google spreadsheet print preview change in real-time. In the print menu, click on the Print option and click on the cell address for the Google Sheets print view.Otherwise, Google Sheets will only select the latest selected group of cells. Select the Google Sheet set print area cells.Here are the steps for how to set print area in Google Sheets for only selected cells: However, we only wish to print the first 10 rows in the dataset. We are going to use the same dataset from the previous example. Thankfully, you can change the print range in Google Sheets to select the cells you wish to print. You may want to do this if you want to present a small part of your work, or you may wish to share specific sections with your colleagues for discussion. Most of the time, you would want to print only some of the spreadsheet. Google Sheets Set Print Area for Selected Cells Once your Google Sheet print area is set to your liking, click on the Print button.You can also change the formatting of the print, where you can change the print’s color and how many copies you wish to create for the spreadsheet. You can also select the Print to PDF option. Click on Printer and select the printer you wish to use to print the spreadsheet. This will take you to your browser’s print settings page.
0 Comments
Leave a Reply. |