![]() ![]() Making sure the Cells Fit the Page Correctly To select this orientation, simply select the radio button next to “ Portrait” under Page orientation. If, instead you have a small number of columns, but want to fit a large number of rows in one page, then go for the portrait orientation. Use this orientation if you have a large number of columns in your selection and want to fit all columns into one page. You should choose a page orientation depending on the number and size of cells in your printed range. Your printer should now start printing your selected cells with your preferred print settings. In the next window, click “ Print” to finish the job and send your completed sheet for printing.Once you have all your print settings in place and your print preview looks good to print, hit the Next button.You can also select other formatting options like grid lines, headers, footers, etc. After this, you can select the other print options like Paper size, page orientation, etc.Click on the “ Selected Cells” option from the list. This will show you a dropdown list of different print options.However, since you only want to print your selected cell range, you need to click on the dropdown arrow under the word “ Print” (which you will find at the top of the sidebar). The default option is to print everything on the current sheet. On the right-hand side, you should see a sidebar with options for different print settings.This will take you to the Print Settings view, where you can see a preview of your printed page/ pages.Alternatively, you could press CTRL+P (if you’re on a PC) or Cmd+P (if you’re on a Mac). You can do this by dragging your mouse over the required area of cells or by pressing down the Shift key to select the first and last cells of your required range. Select the cells that you want to print.Once you have your document ready to print, follow these steps to print a selection of cells from your Google Sheet: How to Print Selected Cells In Google Sheets In this tutorial, we will show you how you can set your print options to print only selected cells in your sheet (i.e., only print the selection and ignore everything else on the sheet). So, it’s important you set your print options to exactly the amount of data you need. Besides making the resulting print look messy, it also ends up wasting paper and ink. If you don’t set the right options, you might end up printing more data than you need. With all these options, it’s sometimes overwhelming when you want to just print a small portion of your worksheet. It also lets you select the size and orientation of the paper you want to print on, the amount of margin you want, and the amount of data you want to print on one page. Google Sheets gives you a number of printing options so that you can print either a whole sheet, a whole table, or just a selection of cells. There are a number of print settings and options that you will need to get right in order to print just what you need. Unfortunately printing spreadsheets onto paper is not exactly as intuitive as printing a word processing document. These data processing software lets you use formulas to consolidate information from datasets, which you can then use to prepare and print reports too. So, you can use the same software to view, analyze, present, and print your data. Spreadsheet software like Google sheets is usually multi-faceted. ![]()
0 Comments
Leave a Reply. |