Even when you have a giant spreadsheet, typically, it’s your decision to print solely selected cells in Google Sheets or Microsoft Excel. There are some in-built choices that allow you to do it rapidly. You possibly can customise and print solely a particular number of cells in Excel and Google Sheets with the assistance of this step-by-step information.
For those who use the default settings or choices in Google Sheets or Microsoft Excel, it’ll print the entire energetic spreadsheet. Now, let’s assume that you’ve a giant spreadsheet with loads of knowledge, however you want to print just some rows and columns due to any motive. These rows and columns may be positioned anyplace in your spreadsheet.
Each instruments have related choices, however they carry completely different names. In different phrases, there isn’t a want to set up an add-on in Google Sheets or Microsoft Excel.
How to print selected cells in Excel
To print selected cells in Excel, observe these steps:
- Open the Excel spreadsheet and choose all cells.
- Press Ctrl+P to print.
- Choose Print Choice from the listing.
- Customise the sheet and print it.
You want to open and choose all of the cells that you really want to print, if you’re utilizing Microsoft Excel. After choosing, press the Ctrl+P shortcut to open the Print immediate. From right here, you want to broaden the Print Energetic Sheets drop-down menu and select the Print Choice possibility.
Now you can also make different adjustments and print the spreadsheet.
How to print selected cells in Google Sheets
To print selected cells in Google Sheets, observe these steps:
- Open the spreadsheet in Google Sheets and use your mouse to choose all cells.
- Press the Print button.
- Select the Selected cells possibility from the listing.
- Customise different settings and print the spreadsheet.
You want to open the spreadsheet in Google Sheets to get began with this tutorial. After that, use your mouse to choose all of the cells that you really want to print. You possibly can click on on a cell and drag your mouse to select all the pieces as per your wants.
After that, click on the Print button seen on the navigation bar. It’s best to get the icon underneath the File/Edit choices. Alternatively, you possibly can go to the File menu and choose the Print possibility. Additionally, you possibly can press Ctrl+P to do the identical.
Now you will discover some choices on your proper aspect. By default, the primary possibility could be the Present sheet. You want to broaden that drop-down listing and choose the Selected cells possibility.
Right here you possibly can see the cell numbers as you selected earlier. After that, you possibly can customise all the pieces to print the spreadsheet accordingly.
That’s it! Hope it helps.
Learn: Excel not printing gridlines correctly [Fix]
How do I print solely sure cells in Google Sheets?
To print solely sure cells in Google Sheets, you want to use your mouse to choose the specified cells first. Then, press the Print button or press the Ctrl+P. Now you want to broaden the drop-down listing and choose the Selected cells possibility. Lastly, you possibly can change settings as per your necessities earlier than beginning the printing course of.
How do I print solely selected cells in Excel?
To print solely selected cells in Excel, you want to open your spreadsheet and select the cells you need to print. Then, press the Ctrl+P or go to File > Print. Subsequent, you want to broaden the drop-down menu and select the Print Choice possibility. After that, you possibly can change or modify all of the required settings as per your necessities. Lastly, click on the Print button to begin printing.
Learn: How to print Doc Properties whereas printing Phrase doc
