You can also click the printer icon from the sub-menu (second image), or press the “Ctrl+P”(“CMD+P” on Mac) keyboard shortcut. The following steps explain how to set the print area to the workbook in Sheets. If you have more than one sheet in your spreadsheet or you want to print the entire spreadsheet, you can set the print area to a workbook. You can also print using the print icon, which is in the toolbar, or using the keyboard shortcut ctrl +P How to Set the Print Area to Print the Whole Workbook You can also add and print labels on your Google Sheet. Usually, this just involves selecting the desired printer and hitting the “Print” button, but you may need to change things like color settings here.įor example, on this Windows 10 system, I’ve selected to print the spreadsheet from the “HP ENVY Photo 7100” destination.Īfter following these steps, you’ll soon have a physical printed copy of your spreadsheet. Hit “Next” and use your operating system’s print management program to send it to the printer.This is what the preview looks like in the example: Check the preview to make sure you’ve highlighted the correct range.The print preview window will change the print area from the entire spreadsheet to just what you selected in a previous step. Click on the “Print Settings” menu option that says “Current Sheet”.You can do this by clicking the File menu then Print option (first image), clicking the printer icon from the sub-menu (second image), or pressing the “Ctrl+P”(“CMD+P” on Mac) keyboard shortcut. In the example below, I’ve selected the first 10 lines and the header row for a range of A1:F11. The following steps explain how to set the print area in Sheets. These are the first 20 references of the spreadsheet: We’ll be using a spreadsheet with user information for this tutorial. The important takeaway from configuring the Google Sheet print area is you need to do it every time you print. If you’re trying to set the print areas in Google Sheets, you probably are trying to avoid using excessive amounts of paper to show a narrowed information selection. How to Set Print Area in Google Sheets for a Range How Do I Set the Print Area Based on Cell Value?.How Do I Make Google Sheets Not Print Lines?.How Do I Print Only a Selected Area in Google Sheets?.Can You Set Print Area on Google Sheets?.How to print a Google Sheet from a mobile app.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |