Method 2: Set Current Sheet or Workbook as Print Area Step 1: Open up your spreadsheet file.Ĭlick the Print button found in the Menu bar. Otherwise, click the Cancel button to go back to your spreadsheet window. You will notice Google Sheets detects and shows you the range of the cells you selected.įor this example, it should show Selected Cells (J1:K7).Ĭlick the Next button if you want to proceed. Once you’re on the Print settings window, click the Print drop-down list and select Selected Cells. Tip: You can always use a shortcut key to show the Print settings window. The Print option is placed at the bottom of the list. This will direct you to the Print settings window.Īlternatively, you may click the File Menu and select Print.
Step 3: Click the Print button.Ĭlick the Print button found at the top-left corner of your spreadsheet window. You need to expand that drop-down list and select the Selected cells option.Note that if you want to print separate sections of your spreadsheet, you will need to repeat this method for each one of them. By default, the first option would be the Current sheet. Now you can find some options on your right hand side. Also, you can press Ctrl + P to do the same. Alternatively, you can go to the File menu and select the Print option. You should get the icon under the File / Edit options. After that, click the Print button visible on the navigation bar. You need to expand that drop-down list and select the Selected cells option. You can click a cell and drag the mouse to choose everything according to your needs. After that, use your mouse to select all the cells you want to print. You must open the spreadsheet in Google Sheets to start this tutorial. Customize other settings and print the spreadsheet.Choose the Selected cells from list option.Open the spreadsheet in Google Sheets and use your mouse to select all cells.To print selected cells in Google Sheets, follow these steps:
Print selection google sheets how to#
How to print selected cells in Google Sheets The following processes explain how to set the printable area to Sheets and configure how the printable area is displayed on paper. Instead, you must define the print area each time you print from Google Sheets. Google Sheets does not contain a “permanent” print area setting. In Excel, before you print content, you define a print area in the layout menu as a permanent setting, while Google Sheets manages the print area each time you print. These two spreadsheet tools handle this task in very different ways. If you’re coming from Microsoft Excel, you might be feeling confused about how Google Sheets handles print area settings. There are a number of print settings and options you need to get exactly what you need to print. Unfortunately, printing spreadsheets on paper is not as intuitive as printing a word processing document. With this data processing software, you can use formulas to consolidate information from the records, which you can then use to generate and print reports.
Print selection google sheets software#
So you can use the same software to view, analyze, present, and print your data. Spreadsheet programs like Google Sheets tend to be versatile. Check How to Print Specific Selection of Cells in Google Sheets
0 kommentar(er)
